Re: autovacuum, exclude table

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: autovacuum, exclude table
Дата
Msg-id CAD2md3EpKvvEwA_+ZggC0iSO5qCNZ3_eZ25N9Gc7cqLkV3FAPg@mail.gmail.com
обсуждение исходный текст
Ответ на autovacuum, exclude table  ("Anibal David Acosta" <aa@devshock.com>)
Ответы Re: autovacuum, exclude table  ("Anibal David Acosta" <aa@devshock.com>)
Список pgsql-performance

Top-posting because this is context free:

You need to provide more info for anybody to help you. Are the tables append-only or are deletes/updates also performed? Also this:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

On Dec 12, 2011 10:26 PM, "Anibal David Acosta" <aa@devshock.com> wrote:

I have a couple of tables with about 400millions of records increasing about 5 millions per day.

 

I think that disabling autovac over those tables, and enabling daily manual vacuum (in some idle hour) will be better.

 

I am right?

 

Is possible to exclude autovacuum over some tables?

 

Thanks!

 

Anibal

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

Предыдущее
От: "Anibal David Acosta"
Дата:
Сообщение: autovacuum, exclude table
Следующее
От: "Anibal David Acosta"
Дата:
Сообщение: Re: autovacuum, exclude table