Re: Poor Performance after Upgrade - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Poor Performance after Upgrade
Date
Msg-id 20070822042425.GA22037@uio.no
Whole thread Raw
In response to Poor Performance after Upgrade  (Ben Perrault <ben@mail.creepingfur.org>)
List pgsql-performance
On Mon, Aug 20, 2007 at 10:17:14PM -0700, Ben Perrault wrote:
>          ->  Nested Loop  (cost=100000000.00..106559138.00 rows=336
> width=137)

This sounds very much like you're trying to force the planner. Did you set
enable_nestloop=false or something? Are there any other non-default settings
that could negatively impact planner performance?

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Optimising "in" queries
Next
From: "vincent"
Date:
Subject: Re: Poor Performance after Upgrade