autovacuum for large periodic deletes - Mailing list pgsql-admin

From Sriram Dandapani
Subject autovacuum for large periodic deletes
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF045AF151@ca-mail1.cis.local
Whole thread Raw
Responses Re: autovacuum for large periodic deletes  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Jeff Frost
Date:
Subject: Re: does wal archiving block the current client connection?
Next
From: Alvaro Herrera
Date:
Subject: Re: autovacuum for large periodic deletes