Re: 7.3.1 New install, large queries are slow
| От | Tom Lane |
|---|---|
| Тема | Re: 7.3.1 New install, large queries are slow |
| Дата | |
| Msg-id | 11770.1042693672@sss.pgh.pa.us обсуждение |
| Ответ на | Re: 7.3.1 New install, large queries are slow (Kevin Brown <kevin@sysexperts.com>) |
| Ответы |
Re: 7.3.1 New install, large queries are slow
|
| Список | pgsql-performance |
Kevin Brown <kevin@sysexperts.com> writes:
> Tom Lane wrote:
>> ... Whether this is a bug or a feature depends on
>> your point of view --- but there are folks out there who find it to be
>> a life-saver.
> Since it *does* depend on one's point of view, would it be possible to
> have control over this implemented in a session-defined variable (with
> the default in the GUC, of course)?
I have no objection to doing that --- anyone care to contribute code to
make it happen? (I think the trick would be to fold plain-JOIN jointree
entries into FROM-list items in planner.c, somewhere near the code that
hoists sub-SELECTs into the main join tree. But I haven't tried it, and
have no time to in the near future.)
regards, tom lane
В списке pgsql-performance по дате отправления: