Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 880759FB1C2 for ; Mon, 9 Oct 2006 18:26:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 98546-03 for ; Mon, 9 Oct 2006 21:26:17 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 260909FA5B5 for ; Mon, 9 Oct 2006 18:26:17 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 2E26556435; Mon, 9 Oct 2006 16:26:16 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 9 Oct 2006 16:26:15 -0500 Date: Mon, 9 Oct 2006 16:26:15 -0500 From: "Jim C. Nasby" To: Medora Schauer Cc: Bill Moran , pgsql-performance@postgresql.org Subject: Re: autovacuum not working? Message-ID: <20061009212615.GN72517@nasby.net> References: <1CA058827877644DAB54FB930FFA3B05D89F73@lincoln.FAIRIND.FAIRFIELD.COM> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1CA058827877644DAB54FB930FFA3B05D89F73@lincoln.FAIRIND.FAIRFIELD.COM> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:061009:mschauer@fairfield.com::3c/0VOcAlzwAcnmQ:000000000000000 0000000000000000000000000zfR X-Hashcash: 1:20:061009:wmoran@collaborativefusion.com::1/0exV+0lIWko1Dp:0000000 0000000000000000000000002IIt X-Hashcash: 1:20:061009:pgsql-performance@postgresql.org::6KjNJGNjWc6m17dc:00000 0000000000000000000000002OiS X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/170 X-Sequence-Number: 21299 On Mon, Oct 09, 2006 at 09:27:30AM -0500, Medora Schauer wrote: > > From your attached config file: > > > > #autovacuum_vacuum_threshold = 1000 # min # of tuple updates before > > # vacuum > > > > Yup, that was it. Actually, not quite. Vacuum will update relpages and reltuples, but it won't update other stats. That's what analyze does (autovacuum_analyze_threshold). By default, that's set to 500; I'll typically drop it to 200 or so (keep in mind that analyze is much cheaper than vacuum). -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)