autovacuum ignore tables

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: autovacuum ignore tables
Date: 2006-09-18 18:33:36
Message-ID: 6992E470F12A444BB787B5C937B9D4DF05DF1ACD@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-09-18 20:32:04 Re: autovacuum ignore tables
Previous Message Jeanna Geier 2006-09-18 18:17:27 Re: Instructions For Building On Windows?