Yes I Analyze also, but there was no need to because it was a fresh brand
new database.

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.


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

Reply via email to