autovacuum for large periodic deletes

Поиск
Список
Период
Сортировка
От Sriram Dandapani
Тема autovacuum for large periodic deletes
Дата
Msg-id 6992E470F12A444BB787B5C937B9D4DF045AF151@ca-mail1.cis.local
обсуждение исходный текст
Ответы Re: autovacuum for large periodic deletes  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-admin

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
Дата:
Сообщение: Re: does wal archiving block the current client connection?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: autovacuum for large periodic deletes