From: Joel Stevenson <joelstevenson@mac.com>
To: Scott Marlowe <smarlowe@g2switchworks.com>
To: adey <adey11@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: vacuumdb exclude tables option?
Date: Thu, 10 Aug 2006 07:44:42 -0700
Message-ID: <p06230919c100f3a08072@[192.168.0.9]> (raw)
In-Reply-To: <1155219418.20252.137.camel@state.g2switchworks.com>
References: <p06230915c0ffd2f2d63b@192.168.0.9>
<1155148097.20252.106.camel@state.g2switchworks.com>
<1c66bda80608092101m272dc6d3pd0145d4fd640cc3@mail.gmail.com>
<1155219418.20252.137.camel@state.g2switchworks.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: joelstevenson@mac.com, smarlowe@g2switchworks.com, adey11@gmail.com
Subject: Re: vacuumdb exclude tables option?
In-Reply-To: <p06230919c100f3a08072@[192.168.0.9]>
References: <p06230915c0ffd2f2d63b@192.168.0.9> <1155148097.20252.106.camel@state.g2switchworks.com> <1c66bda80608092101m272dc6d3pd0145d4fd640cc3@mail.gmail.com> <1155219418.20252.137.camel@state.g2switchworks.com> <p06230919c100f3a08072@[192.168.0.9]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox