From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dave Pirotte <dpirotte@mediamatters.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance problem on 8.2.4, but not 8.2.3
Date: Fri, 25 May 2007 15:56:35 -0400
Message-ID: <21071.1180122995@sss.pgh.pa.us> (raw)
In-Reply-To: <2C91A79B-6AFD-4734-B245-2ED81F4F15D4@mediamatters.org>
References: <2C91A79B-6AFD-4734-B245-2ED81F4F15D4@mediamatters.org>
Dave Pirotte <dpirotte@mediamatters.org> writes:
> We have two servers running pgsql -- an older server running 8.2.3,
> and a newer (far superior) one running 8.2.4. One of our reporting
> queries is running painfully slowly on 8.2.4, but it executes in a
> reasonable timeframe on 8.2.3.
Are you sure you've analyzed all these tables in the 8.2.4 database?
Some of the rowcount estimates seem a bit far off.
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.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, dpirotte@mediamatters.org
Subject: Re: Performance problem on 8.2.4, but not 8.2.3
In-Reply-To: <21071.1180122995@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox