Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Дата
Msg-id 2335.1173798373@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3  (<vincent.moreau@leroymerlin.fr>)
Ответы Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Список pgsql-performance
<vincent.moreau@leroymerlin.fr> writes:
> I was able to improve response time by seting enable_seqscan to off

enable_nestloop = off would probably be a saner choice, at least for
this particular query.

            regards, tom lane

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