How to stop autovacuum for daily partition old tables

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: How to stop autovacuum for daily partition old tables
Date: 2016-01-20 23:22:44
Message-ID: CAGoODpe-Td2bdf-fM1yzFamNPjA4k21Y3iEYXMsykQ7hXraYLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message (Daniel Stolf) 2016-01-21 00:29:34 adding a bdr node using bcv backup
Previous Message Johannes 2016-01-20 21:29:07 long transfer time for binary data