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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
