Re: Poor Performance after Upgrade

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Ben Perrault <ben(at)mail(dot)creepingfur(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor Performance after Upgrade
Date: 2007-08-22 04:24:25
Message-ID: 20070822042425.GA22037@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message vincent 2007-08-22 09:19:11 Re: Poor Performance after Upgrade
Previous Message Scott Marlowe 2007-08-22 04:20:25 Re: Optimising "in" queries