Postgres Pro
Downloads
Home   >   mailing lists

Re: query taking much longer since Postgres 8.4 upgrade - Mailing list pgsql-general

From Tomas Vondra
Subject Re: query taking much longer since Postgres 8.4 upgrade
Date
Msg-id 4D8261B0.5010303@fuzzy.cz
Whole thread Raw
In response to Re: query taking much longer since Postgres 8.4 upgrade  ("Davenport, Julie" <JDavenport@ctcd.edu>)
List pgsql-general
Tree view 
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 by date:

Previous
From: "Davenport, Julie"
Date:
Subject: Re: query taking much longer since Postgres 8.4 upgrade
Next
From: Radosław Smogura
Date:
Subject: Re: PG COPY from version 8 to 9 issue with timezonetz