X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 77EFC9FA48D for ; Thu, 10 Aug 2006 11:46:20 -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 76946-07 for ; Thu, 10 Aug 2006 14:46:11 +0000 (UTC) X-Greylist: delayed 20:21:54.430467 by SQLgrey- Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.178]) by postgresql.org (Postfix) with ESMTP id 15EB79F9998 for ; Thu, 10 Aug 2006 11:46:10 -0300 (ADT) Received: from mac.com (smtpin08-en2 [10.13.10.153]) by smtpout.mac.com (Xserve/8.12.11/smtpout08/MantshX 4.0) with ESMTP id k7AEk6nl018843; Thu, 10 Aug 2006 07:46:06 -0700 (PDT) Received: from [192.168.0.9] ([206.135.69.99]) (authenticated bits=0) by mac.com (Xserve/smtpin08/MantshX 4.0) with ESMTP id k7AEk3oZ019812; Thu, 10 Aug 2006 07:46:05 -0700 (PDT) Mime-Version: 1.0 Message-Id: In-Reply-To: <1155219418.20252.137.camel@state.g2switchworks.com> References: <1155148097.20252.106.camel@state.g2switchworks.com> <1c66bda80608092101m272dc6d3pd0145d4fd640cc3@mail.gmail.com> <1155219418.20252.137.camel@state.g2switchworks.com> Date: Thu, 10 Aug 2006 07:44:42 -0700 To: Scott Marlowe , adey From: Joel Stevenson Subject: Re: vacuumdb exclude tables option? Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset="us-ascii" ; format="flowed" 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: 200608/135 X-Sequence-Number: 22678 Thanks for the reply. I'm still playing around a bit with my autovacuum settings and the manual vaccum runs I'm making are part of an effort to better understand the just what sort of settings I need - I'm running vacuumdb with verbose output, etc. Since I know that these archive tables are append only tables I was just hoping there was a way to skip them more easily and it seemed like it might be something that was not unique to my situation.