From: Arjen van der Meijden <acmmailing@tweakers.net>
To: Jim C. Nasby <jim@nasby.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.2rc1 (much) slower than 8.2dev?
Date: Thu, 07 Dec 2006 10:13:17 +0100
Message-ID: <4577DB2D.6090205@tweakers.net> (raw)
In-Reply-To: <20061207060133.GU44124@nasby.net>
References: <4573D1F7.600@tweakers.net>
<16696.1165244024@sss.pgh.pa.us>
<45744FAA.20603@tweakers.net>
<20061207060133.GU44124@nasby.net>
On 7-12-2006 7:01 Jim C. Nasby wrote:
> Can you post them on the web somewhere so everyone can look at them?
No, its not (only) the size that matters, its the confidentiality I'm
not allowed to just break by myself. Well, at least not on a scale like
that. I've been mailing off-list with Tom and we found at least one
query that in some circumstances takes a lot more time than it should,
due to it mistakenly chosing to do a bitmap index scan rather than a
normal index scan.
> Also, are you looking at EXPLAIN or EXPLAIN ANALYZE?
Explain analyze and normal query execution times of several millions of
queries executed on both versions of postgresql, so we can say something
about them statistically.
Best regards,
Arjen
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: acmmailing@tweakers.net, jim@nasby.net, tgl@sss.pgh.pa.us
Subject: Re: 8.2rc1 (much) slower than 8.2dev?
In-Reply-To: <4577DB2D.6090205@tweakers.net>
* 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