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])

Reply via email to