Re: autovacuum ignore tables

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