Re: vacuumdb exclude tables option?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>, Joel Stevenson <joelstevenson(at)mac(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuumdb exclude tables option?
Date: 2006-08-18 15:32:13
Message-ID: 20060818153213.GM32181@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bruno Wolff III wrote:
> On Wed, Aug 09, 2006 at 11:24:03 -0700,
> Joel Stevenson <joelstevenson(at)mac(dot)com> wrote:
> > I have a database that includes both highly transactional tables and
> > archive tables - OLTP and OLAP mixed together. Some of the archival
> > tables, which only experience inserts and reads, not updates or
> > deletes, contain many millions of rows and so they take a *long* time
> > to vacuum. Is there currently any means to exclude only these tables
> > from vacuumdb operations other than explicitly vacuuming all the
> > other tables and explicity skipping the archival tables?
>
> Take a look at:
> http://developer.postgresql.org/docs/postgres/routine-vacuuming.html#AUTOVACUUM
> There will be a way to have per table settings in 8.2, though the interface
> for setting things up is klunky.
> I also seem to remember some discussion about having a separate transaction
> for each table being cleaned as a new feature.

Hmm, actually a separate transaction is being used for each table since
about forever.

What's new in 8.2 is the ability to ignore other long-running vacuums.
(I think it will help Joel, in that vacuuming the archival tables will
not stop dead tuples from being dropped from the "OLTP tables", though
long-running SELECTs on the OLAP tables will continue to do so.)

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2006-08-18 19:26:24 Inserting a timed delay in a pl/pgsql procedure
Previous Message Bruno Wolff III 2006-08-18 15:25:48 Re: vacuumdb exclude tables option?