From: | Tory M Blue <tmblue(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: bgwriter, checkpoints, curious (seeing delays) |
Date: | 2010-02-26 06:20:38 |
Message-ID: | 8a547c841002252220o4579ead0vd35a44726fdd5c5f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jochen Erwied | 2010-02-26 06:29:22 | Re: bgwriter, checkpoints, curious (seeing delays) |
Previous Message | Tory M Blue | 2010-02-26 06:12:25 | bgwriter, checkpoints, curious (seeing delays) |