On Thu, Jul 15, 2004 at 11:11:33AM -0700, Josh Berkus wrote: >> sort_mem is already 16384, which I thought would be plenty -- I tried >> increasing it to 65536 which made exactly zero difference. :-) > Well, then the next step is increasing the statistical sampling on the 3 join > columns in that table. Try setting statistics to 500 for each of the 3 > cols, analyze, and see if that makes a difference.
Made no difference on either version (7.2 or 7.4). BTW, you guys can stop Cc-ing me now; I'm subscribed. :-) /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])