Postgres Pro
Downloads
Home   >   mailing lists

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

From Merlin Moncure
Subject Re: query taking much longer since Postgres 8.4 upgrade
Date
Msg-id AANLkTimcFMFG4X9wkho2KGvYYmyRCrJRDApVizf=VaJd@mail.gmail.com
Whole thread Raw
In response to Re: query taking much longer since Postgres 8.4 upgrade  ("Davenport, Julie" <JDavenport@ctcd.edu>)
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  ("Davenport, Julie" <JDavenport@ctcd.edu>)
List pgsql-general
Tree view 
On Fri, Mar 18, 2011 at 10:42 AM, Davenport, Julie <JDavenport@ctcd.edu> 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

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: Ben Chobot
Date:
Subject: multi-tenant vs. multi-cluster