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

Предыдущее
От: "Davenport, Julie"
Дата:
Сообщение: Re: query taking much longer since Postgres 8.4 upgrade
Следующее
От: Radosław Smogura
Дата:
Сообщение: Re: PG COPY from version 8 to 9 issue with timezonetz