Re: what should be the best autovacuum configuration for daily partition table

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: what should be the best autovacuum configuration for daily partition table
Дата
Msg-id CAMkU=1wJ+JGQ4kc5W9vxYcfU11UGmAQspKVgDC+0MVK236KBWQ@mail.gmail.com
обсуждение исходный текст
Ответ на what should be the best autovacuum configuration for daily partition table  (AI Rumman <rummandba@gmail.com>)
Ответы Re: what should be the best autovacuum configuration for daily partition table
Список pgsql-general
Дерево обсуждения
On Wed, May 14, 2014 at 12:06 AM, AI Rumman <rummandba@gmail.com> wrote:
Hi,

I have a table with daily partition setup where old partitions are static tables that is after each day we don't get any new data in old partitions.
The database size is 2 TB and I am running with autovacuum on for Postgresql 8.4.
Now, I am facing a problem where old tables are not being vacuumed by autovacuum deamon and every now and then we are seeing autovacuum to prevent wrap around in the database and age(datfrozenzid) gets high for the database.
Any idea what should be best configuration for this type of database environment.

How high is age(datfrozenxid) getting?  What is the problem you are experiencing?  

Cheers,

Jeff

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

Предыдущее
От: chiru r
Дата:
Сообщение: Re: what should be the best autovacuum configuration for daily partition table
Следующее
От: Keith
Дата:
Сообщение: Re: what should be the best autovacuum configuration for daily partition table