Thread: checkpoints too frequent

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
 

>>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:

BM> Vivek, you reported recently that increasing sort_mem and
BM> checkpoint_segments increased performance.  Can you run a test to see
BM> how much of that improvement was just because of increasing
BM> checkpoint_segments?

i was thinking just the same thing myself.

i'll start that run now.