Vivek Khera wrote:
TL == Tom Lane [EMAIL PROTECTED] writes:
TL My best guess is that the dropoffs occur because of background checkpoint
TL operations, but there's not enough info here to prove it. Four inserts
TL per second seems horrendously slow in any case.
I'll concur with this
BM == Bruce Momjian [EMAIL PROTECTED] writes:
Check your logs to see if you are checkpointing too frequently.
BM That warning message is only in 7.4.
Yes, but the checkpoint activity is still logged. On my 7.2 system,
I'm checkpointing about every 1.5 minutes at peak with 3 checkpoint
I am doing to large dataset performance tests with 7.3.4b2 today and I noticed an
interesting phenomenon. My shared memory buffers are set at 128MB. Peak postmaster
usage appears to be around 90MB.
My test app performs inserts across 4 related tables, each set of 4 inserts
representing a