Re: Disable autovacuum on specific tables

Shaun Thomas escribió:
> On 10/24/2012 02:57 PM, Eliot Gable wrote:
>
> >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?
>
> ALTER TABLE foo SET (autovacuum_enabled = false,
> toast.autovacuum_enabled = false);

Note that if you don't set toast.autovacuum_enabled, the toast table
inherits from the main table setting. So you turn it off for both just
by setting autovacuum_enabled=false. The toast setting is there so that
you can set them differently if necessary.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services