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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
