Re: PostgreSQL runs a query much slower than BDE and MySQL - Mailing list pgsql-performance

From Peter Hardman
Subject Re: PostgreSQL runs a query much slower than BDE and MySQL
Date
Msg-id 44E4521E.12188.A4E64B@peter.ssbg.zetnet.co.uk
Whole thread Raw
In response to Re: PostgreSQL runs a query much slower than BDE and MySQL  (Markus Schaber <schabi@logix-tt.com>)
Responses Re: PostgreSQL runs a query much slower than BDE and MySQL  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-performance
On 17 Aug 2006 at 12:11, Markus Schaber wrote:

> 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...
select version() returns

PostgreSQL 8.1.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)

Cheers,--
Peter Hardman
Acre Cottage, Horsebridge
King's Somborne
Stockbridge
SO20 6PT

== Breeder of Shetland Cattle and Shetland Sheep ==


pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: PostgreSQL runs a query much slower than BDE and MySQL
Next
From: Markus Schaber
Date:
Subject: Re: PostgreSQL runs a query much slower than BDE and MySQL