Yes I Analyze also, but there was no need to because it was a fresh brand new database.Advertising
Hmm ... Sorry I'm not sure then. I only use Linux with PG.
Even though it's 'brand new' you still need to Analyze so that any Indexes etc. are built.
I'll keep an eye on this thread - Good luck.
Regards Rudi.
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
