Home > mailing lists

How to stop autovacuum for daily partition old tables - Mailing list pgsql-general

From	AI Rumman
Subject	How to stop autovacuum for daily partition old tables
Date	January 21, 2016 02:22:47
Msg-id	CAGoODpe-Td2bdf-fM1yzFamNPjA4k21Y3iEYXMsykQ7hXraYLg@mail.gmail.com Whole thread Raw
Responses	Re: How to stop autovacuum for daily partition old tables (Melvin Davidson <melvin6925@gmail.com>)
List	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.

From: Johannes
Date: 21 January 2016, 00:29:22
Subject: long transfer time for binary data

From: "(Daniel Stolf)"
Date: 21 January 2016, 03:29:50
Subject: adding a bdr node using bcv backup