Re: vacuumdb in parallel - Mailing list pgsql-admin

From Simon Riggs
Subject Re: vacuumdb in parallel
Date
Msg-id 1255607766.30088.1407.camel@ebony
Whole thread Raw
In response to Re: vacuumdb in parallel  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: vacuumdb in parallel  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
On Wed, 2009-10-14 at 13:57 -0300, Alvaro Herrera wrote:
> Anj Adu escribió:
>
> > I have several "daily" tables that get dropped every day..Is there a
> > wildcard that I can use to tell vacuumdb NOT to vacuum those
> > tables...
>
> No.  You need to do "INSERT INTO pg_autovacuum" (or ALTER TABLE/SET in 8.4)
> just after you've created the table.

This doesn't work with vacuumdb, only with autovacuum.

--
 Simon Riggs           www.2ndQuadrant.com


pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: vacuumdb in parallel
Next
From: Alvaro Herrera
Date:
Subject: Re: vacuumdb in parallel