From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
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
Message-ID: <201101150018.52133.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <4D3069B902000025000395FC@gw.wicourts.gov>
References: <201101111753.22602.achill@matrix.gatewaynet.com>
<201101142259.28928.achill@matrix.gatewaynet.com>
<4D3069B902000025000395FC@gw.wicourts.gov>
Στις Friday 14 January 2011 23:20:25 ο/η Kevin Grittner έγραψε:
> Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
>
> > 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
>
> Sorry to have focused on the wrong issues from your latest post.
> Here's what I suggest to try to get you the best information.
>
> (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 place 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?
>
>
> -Kevin
>
--
Achilleas Mantzios
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-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
In-Reply-To: <201101150018.52133.achill@matrix.gatewaynet.com>
* 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