Just loaded up delicious 7.4b5 and wow...
sort_mem 8192: 137038ms [lots of tmp file activity] sort_mem 256000: 83109ms
Hmm, 298383 -> 83109 (since those are the 256k numbers). Not as much as I'd have hoped, but I'll take a factor of 3.
Hi Jeff,
Could you let us know the load times when you have done:
1. A full ANALYZE 2. A delete all from pg_statistic
So we can see if ANALYZE stats make much difference?
Chris
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly