X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 40957D1B469 for ; Mon, 8 Dec 2003 05:28:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 51692-10 for ; Mon, 8 Dec 2003 01:27:31 -0400 (AST) Received: from mta2.srv.hcvlny.cv.net (mta2.srv.hcvlny.cv.net [167.206.5.68]) by svr1.postgresql.org (Postfix) with ESMTP id 4F6D4D1B436 for ; Mon, 8 Dec 2003 01:27:30 -0400 (AST) Received: from zeut.net (ool-4352919e.dyn.optonline.net [67.82.145.158]) by mta2.srv.hcvlny.cv.net (iPlanet Messaging Server 5.2 HotFix 1.16 (built May 14 2003)) with ESMTP id <0HPK00I889TOJ8@mta2.srv.hcvlny.cv.net> for pgsql-performance@postgresql.org; Mon, 08 Dec 2003 00:27:25 -0500 (EST) Date: Mon, 08 Dec 2003 00:27:29 -0500 From: "Matthew T. O'Connor" Subject: Re: autovacuum daemon stops doing work after about an hour In-reply-to: To: Christopher Browne Cc: pgsql-performance@postgresql.org Message-id: <3FD40BC1.7050906@zeut.net> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 References: <16332.63508.196365.801418@yertle.int.kciLink.com> <1070516326.1455.11.camel@zedora.zeut.net> <16335.25079.106697.7521@yertle.int.kciLink.com> <3FCF7E74.9060604@bigfoot.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/151 X-Sequence-Number: 5011 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.....