| 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 12:45:19 |
| Message-ID: | 1255610719.30088.1488.camel@ebony |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 2009-10-15 at 09:24 -0300, Alvaro Herrera wrote:
> 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).
IIRC he wanted to do vacuum in parallel using 8.1
That's before you did your fine work to improve autovacuum.
--
Simon Riggs www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vishnu S. | 2009-10-16 07:08:35 | Inserting records into a Table in Remote database from another table in remote database |
| Previous Message | Alvaro Herrera | 2009-10-15 12:24:05 | Re: vacuumdb in parallel |