Re: performance with query

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: performance with query
Дата
Msg-id 4A377B340200002500027BFD@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: performance with query  (Alberto Dalmaso <dalmaso@clesius.it>)
Ответы Re: performance with query  (Alberto Dalmaso <dalmaso@clesius.it>)
Список pgsql-performance
Alberto Dalmaso <dalmaso@clesius.it> wrote:

> I attach the explanation of the log query after setting all the
> enable to on. In this condition the query will never finish...

I notice that you many joins in there.  If the query can't be
simplified, you probably need to boost the join_collapse_limit and
from_collapse_limit quite a bit.  If planning time goes through the
roof in that case, you may need to enable geqo -- this is what it's
intended to help.  If you try geqo, you may need to tune it; I'm not
familiar with the knobs for tuning that, so maybe someone else will
jump in if you get to that point.

-Kevin

В списке pgsql-performance по дате отправления:

Предыдущее
От: Alberto Dalmaso
Дата:
Сообщение: Re: performance with query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: performance with query