Re: vacuumdb in parallel

Simon Riggs escribió:
> 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.

Ah, that's right.  But then I see no reason why autovacuum wouldn't work
for him with this (he doesn't seem to have tried it).

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