From: Liviu Ionescu <ilgb@livius.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: performance drop on 8.2.4, reverting to 8.1.4
Date: Fri, 18 May 2007 19:49:30 +0300
Message-ID: <00bc01c7996c$82a66890$653e10ac@ilgvaio> (raw)
In-Reply-To: <20070518162139.GG7069@it.is.rice.edu>
> 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.
you're right. my previous message was not a complain, was a warning for
others to avoid the same mistake. I was overconfident and got bitten. in the
future I'll check my queries on 8.2/8.3/... on a development configuration
before upgrading the production server.
regards,
Liviu
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: ilgb@livius.net
Subject: Re: performance drop on 8.2.4, reverting to 8.1.4
In-Reply-To: <00bc01c7996c$82a66890$653e10ac@ilgvaio>
* 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