Re: Disable autovacuum on specific tables

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);

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email