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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
