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