Re: long checkpoint_timeout - Mailing list pgsql-performance

From Jeff Davis
Subject Re: long checkpoint_timeout
Date
Msg-id 1172262188.10824.248.camel@dogma.v10.wvs
Whole thread Raw
In response to Re: long checkpoint_timeout  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: long checkpoint_timeout
List pgsql-performance
On Fri, 2007-02-23 at 14:02 -0600, Jim C. Nasby wrote:
> > say that checkpoints cause extra disk I/O. Is there a good way to
> > measure how much extra I/O (and WAL volume) is caused by the
> > checkpoints? Also, it would be good to know how much total I/O is caused
> > by a checkpoint so that I know if bgwriter is doing it's job.
>
> There's a patch someone just came up with that provides additional debug
> info about both bgwriter operation and checkpoints. I know it will at
> least tell you how much was written out by a checkpoint.

Excellent, that would answer a lot of my questions. I did some brief
searching and nothing turned up. Do you have a link to the discussion or
the patch?

Regards,
    Jeff Davis


pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: long checkpoint_timeout
Next
From: Josh Berkus
Date:
Subject: Re: which Xeon processors don't have the context switching problem