From: Liviu Ionescu <ilgb@livius.net>
To: pgsql-performance@postgresql.org
Subject: Re: performance drop on 8.2.4, reverting to 8.1.4
Date: Fri, 18 May 2007 16:33:37 +0300
Message-ID: <009501c79951$24596eb0$653e10ac@ilgvaio> (raw)
In-Reply-To: <20070518131047.GA14326@uio.no>
> > it helped, the new version of the query takes 2303 ms on both 8.1.4
> > and 8.2.4.
>
> And the old one?
slightly shorter, 2204 ms.
as a subjective perception, the entire application is slightly slower on 8.2.4, probably there are many queries that were manually tunned for 7.x/8.1.x and now need rewriting, which is not really what I expected from an upgrade.
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: <009501c79951$24596eb0$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