Re: autovacuum ignore tables

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: autovacuum ignore tables
Дата
Msg-id 450F6DB2.5060908@zeut.net
обсуждение исходный текст
Ответ на autovacuum ignore tables  ("Sriram Dandapani" <sdandapani@counterpane.com>)
Список pgsql-admin
Sriram Dandapani wrote:
>
> Hi
>
>
>
> Is it possible to tell autovacuum to ignore certain tables (These
> tables are high traffic daily partition tables that get dropped every
> other day).
>
>
>
> I am trying to get autovacuum to complete quicker and prevent Xactn
> wraparound (currently, it takes very long and due to the fact that I
> have to restart the database for maintenance purposes), autovacuum
> never finishes.)
>
If you are running PostgreSQL 8.1 with integrated autovacuum, then yes,
you can disable autovacuum on a per table basis, if you are using an
older version with the contrib autovacuum, then no.

Matt


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

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: When vaccuum full should be performed with postgresql-8.1
Следующее
От: Josef Springer
Дата:
Сообщение: Installing Postgres 8.1 as a service pn Windows only