Re: odd planner again, pg 9.0.8

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: odd planner again, pg 9.0.8
Дата
Msg-id 27536.1343234349@sss.pgh.pa.us
обсуждение исходный текст
Ответ на odd planner again, pg 9.0.8  (Marcus Engene <mengpg2@engene.se>)
Ответы Re: odd planner again, pg 9.0.8  (Marcus Engene <mengpg2@engene.se>)
Список pgsql-performance
Marcus Engene <mengpg2@engene.se> writes:
> Lacking index hints I have a bit of a problem with a slow select.

I don't think you need index hints.  What you probably do need is to
increase join_collapse_limit and/or from_collapse_limit to deal with
this complex query as a whole.

> There are several selects looking similar to this in our application
> that suddenly jumped from a handfull of ms to many seconds.

Perhaps you had those settings adjusted properly and somebody turned
them off again?

            regards, tom lane

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: odd planner again, pg 9.0.8
Следующее
От: Andres Freund
Дата:
Сообщение: Re: transactions start time