Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 41EFB64FCD7 for ; Wed, 10 Sep 2008 14:48:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43613-04 for ; Wed, 10 Sep 2008 14:48:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 33E9764FCC4 for ; Wed, 10 Sep 2008 14:48:04 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Wed, 10 Sep 2008 12:48:02 -0500 Message-Id: <48C7C1FA.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Wed, 10 Sep 2008 12:47:54 -0500 From: "Kevin Grittner" To: "Scott Marlowe" , "Tom Lane" Cc: ,, , "Matt Smiley" Subject: Re: too many clog files References: <48C5CC04.D078.0028.0@rentrak.com> <48C6F7A5.D078.0028.0@rentrak.com> <48C79A55.EE98.0025.0@wicourts.gov> <2257.1221068560@sss.pgh.pa.us> In-Reply-To: <2257.1221068560@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200809/116 X-Sequence-Number: 31429 >>> Tom Lane wrote: > The expected behavior (in 8.2 and newer) is to maintain about > autovacuum_freeze_max_age transactions' worth of clog; which is to say > about 50MB at the default settings. The active database I checked, where it didn't go all the way back to 0000, had 50 MB of files; so I guess it is working as intended. It sounds like the advice to the OP that running VACUUM FREEZE on all databases to clean up the files was off base? -Kevin