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