Postgres Pro
Downloads
Home   >   mailing lists

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

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

Previous
From: Merlin Moncure
Date:
Subject: Re: SOCK_wait_for_ready function call caused a query to get stuck
Next
From: jonathansfl
Date:
Subject: TO_CHAR(timestamptz,datetimeformat) wrong after DST change