Re: PostgreSQL runs a query much slower than BDE and MySQL

["Peter Hardman" <peter(at)ssbg(dot)zetnet(dot)co(dot)uk>]

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 ==