> "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 checkp
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 co
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 sing