Message-ID: <4577DB2D.6090205@tweakers.net>
Date: Thu, 07 Dec 2006 10:13:17 +0100
From: Arjen van der Meijden <acmmailing@tweakers.net>
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
MIME-Version: 1.0
To: "Jim C. Nasby" <jim@nasby.net>
CC: Tom Lane <tgl@sss.pgh.pa.us>,  pgsql-performance@postgresql.org
Subject: Re: 8.2rc1 (much) slower than 8.2dev?
References: <4573D1F7.600@tweakers.net> <16696.1165244024@sss.pgh.pa.us>
	<45744FAA.20603@tweakers.net> <20061207060133.GU44124@nasby.net>
In-Reply-To: <20061207060133.GU44124@nasby.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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