Re: vacuumdb in parallel

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: vacuumdb in parallel
Дата
Msg-id 1255607766.30088.1407.camel@ebony
обсуждение исходный текст
Ответ на Re: vacuumdb in parallel  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: vacuumdb in parallel
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: vacuumdb in parallel
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: vacuumdb in parallel