Re: [GENERAL] A Question About Insertions -- Performance

2003-09-11 Thread Vivek Khera
> "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

Re: [GENERAL] A Question About Insertions -- Performance

2003-09-11 Thread Bruce Momjian
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

[GENERAL] A Question About Insertions -- Performance

2003-09-10 Thread Clay Luther
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