Re: Configuring PostgreSQL to minimize impact of checkpoints

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuring PostgreSQL to minimize impact of checkpoints
Date: 2004-05-12 19:29:11
Message-ID: A50DAE0E-A44A-11D8-AA3E-000A9578CFCC@kcilink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On May 12, 2004, at 3:22 PM, jao(at)geophile(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bjoern Metzdorf 2004-05-12 22:40:58 Quad processor options - summary
Previous Message jao 2004-05-12 19:22:47 Re: Configuring PostgreSQL to minimize impact of checkpoints