Re: A Question About Insertions -- Performance

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: A Question About Insertions -- Performance
Date: 2003-09-11 16:42:40
Message-ID: 16224.42496.107465.852589@yertle.int.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "BM" == Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomasz Myrta 2003-09-11 16:59:16 Re: MD5 function is not available ?
Previous Message darren 2003-09-11 16:34:25 Re: help with TCL function