Re: performance drop on 8.2.4, reverting to 8.1.4 - Mailing list pgsql-performance

From Guido Neitzer
Subject Re: performance drop on 8.2.4, reverting to 8.1.4
Date
Msg-id E9A8847C-1906-4701-89F2-0ECDFC5F8545@event-s.net
Whole thread Raw
In response to Re: performance drop on 8.2.4, reverting to 8.1.4  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-performance
On 18.05.2007, at 10:21, Kenneth Marshall wrote:

> It is arguable, that updating the DB software version in an enterprise
> environment requires exactly that: check all production queries on the
> new software to identify any issues. In part, this is brought on by
> the
> very tuning that you performed against the previous software. Restore
> the 8.1 DB into 8.2. Then run the queries against both versions to
> evaluate functioning and timing.

And it is always a good idea to do this in a "clean room environment"
aka test server and set the logging in PostgreSQL to log all queries
longer than xx ms. If you first install 8.1 on the test machine, do a
test run and then upgrade to 8.2, you can compare results from the
tests and find the queries that are slower or faster quite easily.

cug

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Efficient recursion
Next
From: "s d"
Date:
Subject: QP Problem