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: Mon, 05 Dec 2005 10:11:41 -0500
Message-ID: <29616.1133795501@sss.pgh.pa.us> (raw)
In-Reply-To: <28011CD60FB1724DBA4442E38277F6264A6BD5@hermes.computec.de>
References: <28011CD60FB1724DBA4442E38277F6264A6BD5@hermes.computec.de>
"Markus Wollny" <Markus.Wollny@computec.de> writes:
>> Could we see the pg_stats row for answer.session_id in both
>> 8.0 and 8.1?
> Here you are:
> 8.1:
> Correlation -0.0736492
> 8.0.3:
> Correlation -0.237136
Interesting --- if the 8.1 database is a dump and restore of the 8.0,
you'd expect the physical ordering to be similar. Why is 8.1 showing
a significantly lower correlation? That has considerable impact on the
estimated cost of an indexscan (plain not bitmap), and so it might
explain why 8.1 is mistakenly avoiding the indexscan ...
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: <29616.1133795501@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