Re: query taking much longer since Postgres 8.4 upgrade

Поиск
Список
Период
Сортировка
От Davenport, Julie
Тема Re: query taking much longer since Postgres 8.4 upgrade
Дата
Msg-id FC3C063A33946548BBC77657D3A2AF750F135C6F@ctc385b.campus.ctcd.org
обсуждение исходный текст
Ответ на 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  (Tomas Vondra <tv@fuzzy.cz>)
Re: query taking much longer since Postgres 8.4 upgrade  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Дерево обсуждения 
This helped, is now down from 14.9 min to 10.9 min to run the entire script.  Thanks.


>>>>Dne 17.3.2011 19:29, Davenport, Julie napsal(a):
>>>> I have not yet had time to try Tomas' suggestion of bumping up the work_mem first (trying to >>>>figure out how to
dothat from within a coldfusion script).  Many thanks for all your help guys!
 

>>Well, just execute this 'SQL query' just like the other ones

>>set work_mem='8MB'

>>and it will increase the amount of memory for that connection.

>>Tomas

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: SOCK_wait_for_ready function call caused a query to get stuck
Следующее
От: jonathansfl
Дата:
Сообщение: TO_CHAR(timestamptz,datetimeformat) wrong after DST change