From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rolf Østvik <rolfostvik@yahoo.no>
Cc: pgsql-performance@postgresql.org, Dennis Bjorklund <db@zigo.dhs.org>
Subject: Re: Worse perfomance on 8.2.0 than on 7.4.14
Date: Mon, 01 Jan 2007 18:30:27 -0500
Message-ID: <21166.1167694227@sss.pgh.pa.us> (raw)
In-Reply-To: <20070101150410.51809.qmail@web26309.mail.ukl.yahoo.com>
References: <20070101150410.51809.qmail@web26309.mail.ukl.yahoo.com>
=?iso-8859-1?q?Rolf=20=D8stvik?= <rolfostvik@yahoo.no> writes:
> First i have some queries to give you a feel of size
> of datasets and plans and times.
You said earlier that essentially all the rows of step_result_subset
have step_parent = 0 ... is that really true? I can hardly believe
that either 7.4 or 8.2 would use an indexscan for Q-A if so.
I'd be interested to see the results of
prepare foo(int) as select id from step_result_subset sr
where uut_result = $1 and step_parent = 0;
explain analyze execute foo(42);
(use some representative uut_result value instead of 42). If it doesn't
want to use an indexscan for this, disable plan types until it does.
This would perhaps shed some light on why 8.2 doesn't want to use a scan
like that as the inside of a nestloop.
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, rolfostvik@yahoo.no, db@zigo.dhs.org
Subject: Re: Worse perfomance on 8.2.0 than on 7.4.14
In-Reply-To: <21166.1167694227@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