On Jun 27, 2004, at 8:37 PM, Jim wrote:
Hi,
I have one performance issue... and realy have no idea what's going on...
When I set enable_seqscan to 0, query2 runs the same way...
upload => 60667 entities uploadfield => 506316 entities
Have you vacuum analyze'd recently?
-- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/
---------------------------(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
