Re: Performance problem on 8.2.4, but not 8.2.3 - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Performance problem on 8.2.4, but not 8.2.3
Date
Msg-id 20070525200523.GA15547@uio.no
Whole thread Raw
In response to Re: Performance problem on 8.2.4, but not 8.2.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Performance problem on 8.2.4, but not 8.2.3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Fri, May 25, 2007 at 03:56:35PM -0400, Tom Lane wrote:
> I looked through the CVS logs and didn't find any planner changes
> between 8.2.3 and 8.2.4 that seem likely to affect your query, so
> I'm thinking it must be a statistical discrepancy.

It looks like the estimated cost is lower for 8.2.4 -- could it be that the
fact that he's giving it more memory lead to the planner picking a plan that
happens to be worse?

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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance problem on 8.2.4, but not 8.2.3
Next
From: Tom Lane
Date:
Subject: Re: Performance problem on 8.2.4, but not 8.2.3