From: Tom Lane <tgl@sss.pgh.pa.us>
To: Markus Wollny <Markus.Wollny@computec.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Date: Thu, 01 Dec 2005 11:26:04 -0500
Message-ID: <11568.1133454364@sss.pgh.pa.us> (raw)
In-Reply-To: <28011CD60FB1724DBA4442E38277F6264A626A@hermes.computec.de>
References: <28011CD60FB1724DBA4442E38277F6264A626A@hermes.computec.de>
"Markus Wollny" <Markus.Wollny@computec.de> writes:
> My current problem is that rewriting hundreds of queries, some of them
> quite a bit more complex than this one, but all of them using the same
> general scheme, would take quite a lot of time - and I'm expected to
> hand over the survey results ASAP. So I will obviously have to do a
> rewrite if there's just no other way, but I wondered if there might be
> some other option that would allow me to point the planner in the right
> direction so it would behave the same as in the previous versions,
> namely 8.0?
It looks like "set enable_nestloop = 0" might be a workable hack for
the immediate need. Once you're not under deadline, I'd like to
investigate more closely to find out why 8.1 does worse than 8.0 here.
regards, tom lane
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: tgl@sss.pgh.pa.us, Markus.Wollny@computec.de
Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
In-Reply-To: <11568.1133454364@sss.pgh.pa.us>
* 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