Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 53DB62E008B for ; Mon, 17 Mar 2008 12:08:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 30629-01-4 for ; Mon, 17 Mar 2008 12:07:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 5783D2E2DA7 for ; Mon, 17 Mar 2008 11:57:43 -0300 (ADT) Received: from perhan.alvh.no-ip.org (200-126-114-75.bk8-dsl.surnet.cl [200.126.114.75]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m2HEw50O018365 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 17 Mar 2008 07:58:07 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 3888147BFE; Mon, 17 Mar 2008 11:57:34 -0300 (CLST) Date: Mon, 17 Mar 2008 11:57:34 -0300 From: Alvaro Herrera To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: auto_vacuum question Message-ID: <20080317145734.GE4317@alvh.no-ip.org> References: <004a01c8883b$86b9f140$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <004a01c8883b$86b9f140$14010a0a@dei26g028575> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Mon, 17 Mar 2008 07:58:07 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/123 X-Sequence-Number: 28606 Mark Steben wrote: > We upgraded from postgres 7.4.5 to 8.2.5 a couple weekends ago. I just > turned auto vacuum on today. > > I manually inserted 4 entries in PG_AUTOVACUUM with enabled = 'f' to exclude > these larger tables > That we manually vacuum every night. But the first tables that autovacuum > chooses to vacuum are > > These 4 tables. Am I missing something? My guess is that you set the rest of the settings to 0, particularly for the freeze settings. In that case, try changing them to -1. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.