From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Eliot Gable <egable+pgsql-general(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Disable autovacuum on specific tables |
Date: | 2012-10-24 20:15:09 |
Message-ID: | 20121024201509.GG6853@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Eliot Gable escribió:
> In general, autovacuum seems to work well on most of the tables I deal
> with. However, in a couple of specific cases, it seems to fail miserably. I
> would like to switch to manual vacuuming on those tables and disable
> auto-vacuuming for those tables alone. Is this possible?
Of course. Exactly how you do it depends on the server version. In
versions earlier than 8.4 you had to manually insert a tuple in the
pg_autovacuum catalog, with its "enabled" flag set to false and ensure
that all other settings are -1 (not zero).
In 8.4 and up, just do
ALTER TABLE foo SET (autovacuum_enabled = false)
See
http://www.postgresql.org/docs/8.4/static/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS
for docs.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2012-10-24 20:17:28 | Re: Disable autovacuum on specific tables |
Previous Message | Shaun Thomas | 2012-10-24 20:06:15 | Re: Disable autovacuum on specific tables |