autovacuum for large periodic deletes

Поиск
Список
Период
Сортировка
Искать
От
Sriram Dandapani
Тема
autovacuum for large periodic deletes
Дата
в 15:52:27
Msg-id
6992E470F12A444BB787B5C937B9D4DF045AF151@ca-mail1.cis.local
Список
Дерево обсуждения
Re: autovacuum for large periodic deletes "Sriram Dandapani" <sdandapani@counterpane.com>
Re: autovacuum for large periodic deletes "Jim C. Nasby" <jnasby@pervasive.com>

Hi

 

Every night, a delete of about 50 million rows occurs on a table. Do we need to explicitly vacuum the table or will autovacuum handle the large deletes without affecting performance. I am trying to determine whether or not I should completely rely on autovacuum or also tinker with manual vacuums.

 

Sriram

В списке pgsql-admin по дате отправления
Предыдущее
От: Jeff Frost
Дата:
Следующее
От: Alvaro Herrera
Дата:
FAQ