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