Incredible! Setting enable_nestloop off temporarily for the run of this script made it run in less than a minute (had been running in 10 or 11 minutes). I think you have found a solution for many of my slow running scripts that use these same type of joins. Thanks again. Julie
>>-----Original Message----- >>From: Merlin Moncure [mailto:[email protected]] >>Sent: Friday, March 18, 2011 1:18 PM >>To: Davenport, Julie >>Cc: Tomas Vondra; [email protected] >>Subject: Re: [GENERAL] query taking much longer since Postgres 8.4 upgrade >>>>On Fri, Mar 18, 2011 at 10:42 AM, Davenport, Julie <[email protected]> >>>>wrote: >>>> This helped, is now down from 14.9 min to 10.9 min to run the entire >>>> script. Thanks. >>can you try disabling nestloop and see what happens? In the session, >>before running the query, isssue: >>set enable_nestloop = false; >>merlin -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
