Re: autovacuum ignore tables

["Matthew T. O'Connor" <matthew@xxxxxxxx>]

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