Re: Configuring PostgreSQL to minimize impact of checkpoints - Mailing list pgsql-performance

From Vivek Khera
Subject Re: Configuring PostgreSQL to minimize impact of checkpoints
Date
Msg-id A50DAE0E-A44A-11D8-AA3E-000A9578CFCC@kcilink.com
Whole thread Raw
In response to Re: Configuring PostgreSQL to minimize impact of checkpoints  (jao@geophile.com)
List pgsql-performance
On May 12, 2004, at 3:22 PM, jao@geophile.com wrote:

>>
>> I don't see that.  But I also set checkpoint segments to about 50 on
>> my big server.
>
> But wouldn't that affect checkpoint frequency, not checkpoint cost

Seems reasonable.  I suppose checkpointing doesn't cost as much disk
I/O as vacuum does.  My checkpoints are also on a separate RAID volume
on a separate RAID channel, so perhaps that gives me extra bandwidth to
perform the checkpoints.



pgsql-performance by date:

Previous
From: jao@geophile.com
Date:
Subject: Re: Configuring PostgreSQL to minimize impact of checkpoints
Next
From: Bjoern Metzdorf
Date:
Subject: Quad processor options - summary