Skip site navigation (1) Skip section navigation (2)

Re: autovacuum for large periodic deletes

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Sriram Dandapani <sdandapani(at)counterpane(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: autovacuum for large periodic deletes
Date: 2006-05-17 20:36:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Sriram Dandapani wrote:

> 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.

How many rows stay in the table after the massive deletion?  It may be
that it's best for you to issue a CLUSTER or VACUUM FULL instead of
VACUUM.  (In any case, autovacuum would vacuum the table eventually, but
maybe you can do better.)

Alvaro Herrera                      
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-admin by date

Next:From: Sriram DandapaniDate: 2006-05-17 20:39:35
Subject: Re: autovacuum for large periodic deletes
Previous:From: Sriram DandapaniDate: 2006-05-17 18:52:03
Subject: autovacuum for large periodic deletes

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group