On Jul 17, 2005, at 1:08 PM, Christopher Petrilli wrote:
> Normally, checkpoint_segments can help absorb some of that, but my
> experience is that if I crank the number up, it simply delays the
> impact, and when it occurs, it takes a VERY long time (minutes) to
There comes a point where your only recourse is to throw hardware at
the problem. I would suspect that getting faster disks and splitting
the checkpoint log to its own RAID partition would help you here.
Adding more RAM while you're at it always does wonders for me :-)
Vivek Khera, Ph.D.
In response to
pgsql-performance by date
|Next:||From: Christopher Petrilli||Date: 2005-07-18 18:45:35|
|Subject: Re: Impact of checkpoint_segments under continual load conditions|
|Previous:||From: Robert Creager||Date: 2005-07-18 18:21:03|
|Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?|