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>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AceZaP35lvpgz27tT1mfyK3zhg0hcwAAtnjQ
In-Reply-To: <20070518162139.GG7069@it.is.rice.edu>
Importance: Normal

> It is arguable, that updating the DB software version in an=20
> enterprise environment requires exactly that: check all=20
> production queries on the new software to identify any=20
> issues. In part, this is brought on by the very tuning that=20
> you performed against the previous software. Restore the 8.1=20
> DB into 8.2. Then run the queries against both versions to=20
> 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