Re: How to stop autovacuum for daily partition old tables

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: How to stop autovacuum for daily partition old tables
Дата
Msg-id CANu8FiytvrOfu_g3UgOy3A+fazixS-e4ETeReMUhxTftsPXvOw@mail.gmail.com
обсуждение исходный текст
Ответ на How to stop autovacuum for daily partition old tables  (AI Rumman <rummandba@gmail.com>)
Ответы Re: How to stop autovacuum for daily partition old tables  (AI Rumman <rummandba@gmail.com>)
Список pgsql-general
Дерево обсуждения

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 <rummandba@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.

В списке pgsql-general по дате отправления:

Предыдущее
От: "(Daniel Stolf)"
Дата:
Сообщение: adding a bdr node using bcv backup
Следующее
От: AI Rumman
Дата:
Сообщение: Re: How to stop autovacuum for daily partition old tables