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: 20060517203621.GR26367@surnet.cl (view raw or flat)
Thread:
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                                http://www.CommandPrompt.com/
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-2014 The PostgreSQL Global Development Group