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/