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 по дате отправления:

Предыдущее
От: "Dave Dutcher"
Дата:
Сообщение: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Следующее
От: "Dengler, Michael"
Дата:
Сообщение: Autocommit in libpq