Message-ID: <44E440E5.4060304@logix-tt.com>
Date: Thu, 17 Aug 2006 12:11:49 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Thunderbird 1.5.0.4 (X11/20060713)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL runs a query much slower than BDE and MySQL
References: <44E35A5D.19933.35F376@peter.ssbg.zetnet.co.uk>
	<44E4430D.15373.6A0C60@peter.ssbg.zetnet.co.uk>
In-Reply-To: <44E4430D.15373.6A0C60@peter.ssbg.zetnet.co.uk>
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit

Hi, Peter,

Peter Hardman wrote:

>> BTW, are you *sure* you are testing PG 8.1?  The "Subquery Scan f2" plan
>> node looks unnecessary to me, and I'd have expected 8.1 to drop it out.
>> 8.0 and before would have left it in the plan though.  This doesn't make
>> all that much difference performance-wise in itself, but it does make me
>> wonder what you are testing.
> 
> Yes, the executables all say version 8.1.3.6044

Would you mind to look at the output of "select version();", too?

I ask this because I stumbled over it myself, that I had installed the
correct postgresql and psql versions, but accidentally connected to a
different database installation due to strange environment and script
settings...


Thanks,
Markus


-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org