Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id E65B89FC28A
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 18 May 2007 10:34:34 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 36373-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 18 May 2007 10:34:28 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail.livius.net (mail.livius.net [80.86.96.82])
	by postgresql.org (Postfix) with ESMTP id BC0789FC277
	for <pgsql-performance@postgresql.org>;
	Fri, 18 May 2007 10:34:27 -0300 (ADT)
Received: from ilgvaio (86-120-229-138.rdsnet.ro [86.120.229.138] (may be
	forged)) (authenticated bits=0)
	by mail.livius.net (8.12.5/8.12.5) with ESMTP id l4IDYOeF012183
	for <pgsql-performance@postgresql.org>; Fri, 18 May 2007 16:34:24 +0300
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>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.6822
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
Thread-Index: AceZTpdnf0yS7z6NTq6w3uFKiSYfagAAYLXw
In-Reply-To: <20070518131047.GA14326@uio.no>
Importance: Normal
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200705/320
X-Sequence-Number: 24710

> > it helped, the new version of the query takes 2303 ms on both 8.1.4=20
> > and 8.2.4.
>=20
> 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.
=20

Liviu