From: Bruno Wolff III <bruno@wolff.to>
To: Ryszard Lach <ryszard@lach.name>
Cc: pgsql-performance@postgresql.org
Subject: Re: 7.3 vs 7.2 - different query plan, bad performance
Date: Fri, 13 Jun 2003 13:54:05 -0500
Message-ID: <20030613185405.GB19711@wolff.to> (raw)
In-Reply-To: <20030613184506.GE21614@siaco.id.pl>
References: <20030613184506.GE21614@siaco.id.pl>
On Fri, Jun 13, 2003 at 20:45:06 +0200,
Ryszard Lach <siaco@autograf.pl> wrote:
> I can't understand where comes the big difference in query plan from, and
> (that's more important) - how to force postgres 7.3 to execute it more
> efficient?
I am guessing that your are really using 7.3.x and not 7.3. There was
a bug in 7.3 that was fixed in 7.3.1 or 7.3.2 with subselects. However
this fix was made with safety in mind (as it was a point release)
and resulted in some queries running slower. A complete fix was made for
7.4. To test to see if this is really the problem, you could try a 7.4
snapshot or 7.3 to see if you get improved plans.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: bruno@wolff.to, ryszard@lach.name
Subject: Re: 7.3 vs 7.2 - different query plan, bad performance
In-Reply-To: <20030613185405.GB19711@wolff.to>
References: <20030613184506.GE21614@siaco.id.pl> <20030613185405.GB19711@wolff.to>
* 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