Vivek, you reported recently that increasing sort_mem and
checkpoint_segments increased performance. Can you run a test to see
how much of that improvement was just because of increasing
checkpoint_segments?
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073