Gary Stainburn <[EMAIL PROTECTED]> writes: > Anyone got any ideas of the cause, or thoughts on how I can trace the > problem?
EXPLAIN ANALYZE results for the fast and slow cases would be interesting. Also, have you ANALYZEd the underlying tables lately? And what PG version is this? regards, tom lane ---------------------------(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