Re: vacuumdb in parallel

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Anj Adu <fotographs(at)gmail(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuumdb in parallel
Date: 2009-10-15 11:56:06
Message-ID: 1255607766.30088.1407.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2009-10-15 12:24:05 Re: vacuumdb in parallel
Previous Message Alvaro Herrera 2009-10-14 16:57:20 Re: vacuumdb in parallel