Re: A Question About Insertions -- Performance - Mailing list pgsql-general

From Vivek Khera
Subject Re: A Question About Insertions -- Performance
Date
Msg-id 16224.42496.107465.852589@yertle.int.kciLink.com
Whole thread Raw
In response to Re: A Question About Insertions -- Performance  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
>>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> 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
segments.  I think I can speed it up even more by increasing them.


pgsql-general by date:

Previous
From: darren@crystalballinc.com
Date:
Subject: Re: help with TCL function
Next
From: Tom Lane
Date:
Subject: Re: How to avoid inlining subquery result columns