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 9D4649FB2DA for ; Thu, 10 Aug 2006 12:26:49 -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 91367-05 for ; Thu, 10 Aug 2006 15:26:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id DF1B49FB304 for ; Thu, 10 Aug 2006 12:26:40 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 10 Aug 2006 15:26:39 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 10 Aug 2006 10:26:39 -0500 Subject: Re: vacuumdb exclude tables option? From: Scott Marlowe To: Joel Stevenson Cc: adey , pgsql-admin@postgresql.org In-Reply-To: References: <1155148097.20252.106.camel@state.g2switchworks.com> <1c66bda80608092101m272dc6d3pd0145d4fd640cc3@mail.gmail.com> <1155219418.20252.137.camel@state.g2switchworks.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1155223599.20252.140.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 10 Aug 2006 10:26:39 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200608/136 X-Sequence-Number: 22679 On Thu, 2006-08-10 at 09:44, Joel Stevenson wrote: > 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. Something you can look at doing it running autovacuum with different settings depending on the time of day. That way, with more aggresive settings it will trigger on those less used tables during off hours and during the day (hopefully) leave them alone all the time. Note that autovacuum also runs analyzes on your tables as needed as well, so even if those archive tables don't need vacuuming, they might well need analyzing. You can adjust the settings for those things separately, btw.