ALTER TABLE your_schema.your_table SET (autovacuum_enabled = false, toast.autovacuum_enabled = false);
On Wed, Jan 20, 2016 at 6:22 PM, AI Rumman <rumman...@gmail.com> wrote: > Hi, > > I have a table with daily partition schema on Postgresql 9.1 where we are > keeping 2 years of data. > Often I experience that autovacuum process is busy with old tables where > there is no change. How can I stop it? > Please advice. > > Thanks. > > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
