Re: query taking much longer since Postgres 8.4 upgrade

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: query taking much longer since Postgres 8.4 upgrade
Дата
Msg-id AANLkTimcFMFG4X9wkho2KGvYYmyRCrJRDApVizf=VaJd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: query taking much longer since Postgres 8.4 upgrade  ("Davenport, Julie" <JDavenport@ctcd.edu>)
Ответы Re: query taking much longer since Postgres 8.4 upgrade  (Tomas Vondra <tv@fuzzy.cz>)
Re: query taking much longer since Postgres 8.4 upgrade  ("Davenport, Julie" <JDavenport@ctcd.edu>)
Список pgsql-general
Дерево обсуждения 
On Fri, Mar 18, 2011 at 10:42 AM, Davenport, Julie <JDavenport@ctcd.edu> wrote:
> This helped, is now down from 14.9 min to 10.9 min to run the entire script.  Thanks.

can you try disabling nestloop and see what happens?   In the session,
before running the query, isssue:
set enable_nestloop = false;

merlin

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: SOCK_wait_for_ready function call caused a query to get stuck
Следующее
От: Ben Chobot
Дата:
Сообщение: multi-tenant vs. multi-cluster