From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: Postgresql 9.0.2 explain analyze very slow (10x),
	compared to actual query time
Date: Sat, 15 Jan 2011 00:18:51 +0200
User-Agent: KMail/1.9.7
References: <201101111753.22602.achill@matrix.gatewaynet.com>
	<201101142259.28928.achill@matrix.gatewaynet.com>
	<4D3069B902000025000395FC@gw.wicourts.gov>
In-Reply-To: <4D3069B902000025000395FC@gw.wicourts.gov>
MIME-Version: 1.0
Content-Disposition: inline
Message-Id: <201101150018.52133.achill@matrix.gatewaynet.com>
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=CE=A3=CF=84=CE=B9=CF=82 Friday 14 January 2011 23:20:25 =CE=BF/=CE=B7 Kevi=
n Grittner =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
> =20
> > What i am asking is ways to understand what is going on, and what
> > to expect when i will have to actually perform the production
> > upgrade to 9.0.2
> =20
> Sorry to have focused on the wrong issues from your latest post.=20
> Here's what I suggest to try to get you the best information.
> =20
> (1)  Abandon this thread, start a new one on the performance list
> with a different subject line.

I agree about the subject line. But whouldn't -bugs be a more apropriate pl=
ace than -performance?
Pre 8.3 (e.g. 7.4), EXISTS used to run faster than IN, this was fixed in 8.=
3 (which was IMO a milestone in postgresql performance) ,
should not that be the case with 9.0 as well?

> =20
> =20
> -Kevin
>=20


=2D-=20
Achilleas Mantzios