X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F2C6EDB68A for ; Sun, 13 Nov 2005 15:05:34 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61313-04 for ; Sun, 13 Nov 2005 19:05:33 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181]) by svr1.postgresql.org (Postfix) with ESMTP id B77EBDB699 for ; Sun, 13 Nov 2005 15:05:30 -0400 (AST) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx2.surnet.cl with ESMTP; 13 Nov 2005 16:06:26 -0300 X-IronPort-AV: i="3.97,323,1125892800"; d="scan'208"; a="26355803:sNHT701889408" Received: from alvh.no-ip.org (216.155.78.23) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 43501597003B8D96; Sun, 13 Nov 2005 16:05:26 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 5ACEBC2D450; Sun, 13 Nov 2005 16:05:53 -0300 (CLST) Date: Sun, 13 Nov 2005 16:05:53 -0300 From: Alvaro Herrera To: Stephen Byers Cc: Tom Lane , pgsql-admin@postgresql.org Subject: Re: autovacuum on updated rows Message-ID: <20051113190553.GH29473@surnet.cl> Mail-Followup-To: Stephen Byers , Tom Lane , pgsql-admin@postgresql.org References: <21367.1131741515@sss.pgh.pa.us> <20051111210520.94871.qmail@web30714.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20051111210520.94871.qmail@web30714.mail.mud.yahoo.com> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.859 required=5 tests=[AWL=-0.387, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, RCVD_IN_NJABL_PROXY=0.327] X-Spam-Score: 1.859 X-Spam-Level: * X-Archive-Number: 200511/147 X-Sequence-Number: 19520 Stephen Byers wrote: > Sorry for noise. It turns out that little pound sign in front bit me !! > #autovacuum = on So, does it work after you activate it? Please note that there's a threshold in the number of tuples that will need to be modified for a vacuum operation to be launched. For such a small table you may want to lower the threshold a bit. See the docs on the pg_autovacuum system catalog, in the "internals" chapter. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support