Re: bgwriter, checkpoints, curious (seeing delays)

On Thu, Feb 25, 2010 at 10:12 PM, Tory M Blue <tmblue(at)gmail(dot)com> wrote:
> Okay ladies and gents and the rest of you :)
>
> It's time I dig into another issue, and that's a curious 5 second
> delay on connect, on occasion. Now, I believe the network to be sound
> and there are zero errors on any servers, no retrans, no runts, nada
> nada nada. However I will continue to run tests with/without dns,
> tcpdumps, tracking communications, handshakes, however.
>
> I've been doing some reading and what did I find. I found "Checkpoints
> are very disrupting to your database performance and can cause
> connections to stall for up to a few seconds while they occur."

Quick added note, sorry.

"checkpoint_completion_target (floating point)

Specifies the target length of checkpoints, as a fraction of the
checkpoint interval. The default is 0.5. This parameter can only be
set in the postgresql.conf file or on the server command line. "

interesting that it's a .5 second default setting and I'm seeing
exactly that .5 second delay.

Again could be reaching here!

Thanks for putting up with me

Tory