Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 41ABE2E02D8 for ; Mon, 17 Mar 2008 12:28:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 53701-03-6 for ; Mon, 17 Mar 2008 12:28:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 38CC52E2F81 for ; Mon, 17 Mar 2008 12:17:37 -0300 (ADT) Received: (qmail 4363 invoked from network); 17 Mar 2008 11:19:17 -0400 Received: from unknown (HELO dei26g028575) (msteben@10.10.1.20) by mail.autorevenue.com with SMTP; 17 Mar 2008 11:19:17 -0400 From: "Mark Steben" To: "'Alvaro Herrera'" Cc: Subject: Re: auto_vacuum question Date: Mon, 17 Mar 2008 11:17:23 -0400 Message-ID: <005901c88842$0033c130$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <20080317145734.GE4317@alvh.no-ip.org> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Thread-Index: AciIP4Le1jgK/w/OR6Oe0Wxon/Q6KAAAlxBg X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/125 X-Sequence-Number: 28608 Thanks Alvaro - did as you suggested and looks to be working better Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben@autorevenue.com Visit our new website at www.autorevenue.com IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it. Thank you. -----Original Message----- From: Alvaro Herrera [mailto:alvherre@commandprompt.com] Sent: Monday, March 17, 2008 10:58 AM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] auto_vacuum question 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.