Re: bgwriter, checkpoints, curious (seeing delays)

On Feb 26, 2010, at 11:23 AM, Tory M Blue wrote:

> On Fri, Feb 26, 2010 at 5:09 AM, Kevin Grittner
> <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>> Tory M Blue wrote:
>>
>>> 2010-02-25 22:53:13 PST LOG: checkpoint starting: time
>>> 2010-02-25 22:53:17 PST postgres postgres [local] LOG: unexpected
>>> EOF on client connection
>>> 2010-02-25 22:55:43 PST LOG: checkpoint complete: wrote 34155
>>> buffers (17.8%); 0 transaction log file(s) added, 0 removed, 15
>>> recycled; write=150.045 s, sync=0.000 s, total=150.046 s
>>
>> Did that unexpected EOF correspond to a connection attempt that gave
>> up based on time?
>>
>> -Kevin
>>
> Kevin
>
> Good question, I'm unclear what that was. I mean it's a LOG, so not a
> client connection, that really kind of confused me. I don't normally
> see EOF of client and an EOF on client from local, that's really
> really weird

We see that from our monitoring software testing port 5432.