Re: query taking much longer since Postgres 8.4 upgrade

From: "Davenport, Julie" <JDavenport(at)ctcd(dot)edu>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: query taking much longer since Postgres 8.4 upgrade
Date: 2011-03-18 15:42:47
Message-ID: FC3C063A33946548BBC77657D3A2AF750F135C6F@ctc385b.campus.ctcd.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 do that 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bubba postgres 2011-03-18 16:11:37 Re: why does extract ( HOUR FROM TIMESTAMP '2010-01-01 00:00:00' at time zone 'utc' ) == 16?
Previous Message Merlin Moncure 2011-03-18 15:26:11 Re: SOCK_wait_for_ready function call caused a query to get stuck