Re: autovacuum daemon stops doing work after about an hour - Mailing list pgsql-performance

From Matthew T. O'Connor
Subject Re: autovacuum daemon stops doing work after about an hour
Date
Msg-id 3FD40BC1.7050906@zeut.net
Whole thread Raw
In response to Re: autovacuum daemon stops doing work after about an hour  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-performance
Christopher Browne wrote:

>The world rejoiced as mendola@bigfoot.com (Gaetano Mendola) wrote:
>
>
>>I think is a good Idea put a fflush after:
>>
>>fprintf(LOGOUTPUT, "[%s] %s\n", timebuffer, logentry);
>>
>>
>
>I thought I had put fflush()es at all the interesting locations...
>
>

I just looked through the code, I think there are fflush()es at all but
one interesting locations.  The last log_entry call before sleeping
doesn't have an fflush call after it.  I'll submit a patch that adds it.

>Apparently it was an error to not go to the effort of making sure it
>worked well on FreeBSD.  (It was on my list, but I never got the Round
>Tuits...)  There's an AMD-64 box coming in soon, targeted at FreeBSD,
>so that should change...
>
>
Yeah, FreeBSD testing would have been nice, but I don't have access to
any FreeBSD boxes so.....


pgsql-performance by date:

Previous
From: Christopher Browne
Date:
Subject: Re: autovacuum daemon stops doing work after about an hour
Next
From: Steve Wampler
Date:
Subject: Re: Help tracking down problem with inserts slowing