autovacuum ignore tables - Mailing list pgsql-admin

From Sriram Dandapani
Subject autovacuum ignore tables
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF05DF1ACD@ca-mail1.cis.local
Whole thread Raw
Responses Re: autovacuum ignore tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: autovacuum ignore tables  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-admin

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.)

pgsql-admin by date:

Previous
From: "Jeanna Geier"
Date:
Subject: Re: Instructions For Building On Windows?
Next
From: Tom Lane
Date:
Subject: Re: autovacuum ignore tables