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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
