Re: vacuumdb in parallel

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(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-14 16:57:20
Message-ID: 20091014165720.GD4902@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2009-10-15 11:56:06 Re: vacuumdb in parallel
Previous Message Anj Adu 2009-10-14 15:46:28 Re: vacuumdb in parallel