Re: query taking much longer since Postgres 8.4 upgrade

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: "Davenport, Julie" <JDavenport(at)ctcd(dot)edu>
Cc: 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 18:18:08
Message-ID: AANLkTimcFMFG4X9wkho2KGvYYmyRCrJRDApVizf=VaJd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 18, 2011 at 10:42 AM, Davenport, Julie <JDavenport(at)ctcd(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Voras 2011-03-18 18:47:20 Re: multi-tenant vs. multi-cluster
Previous Message Ben Chobot 2011-03-18 18:17:53 multi-tenant vs. multi-cluster