Re: query taking much longer since Postgres 8.4 upgrade

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: query taking much longer since Postgres 8.4 upgrade
Дата
Msg-id 4D8261B0.5010303@fuzzy.cz
обсуждение исходный текст
Ответ на Re: query taking much longer since Postgres 8.4 upgrade  ("Davenport, Julie" <JDavenport@ctcd.edu>)
Список pgsql-general
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 do
thatfrom 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 по дате отправления: