Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
autovacuum for large periodic deletes
- From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
- To: <pgsql-admin(at)postgresql(dot)org>
- Subject: autovacuum for large periodic deletes
- Date: Wed, 17 May 2006 11:52:03 -0700
|
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 |
- Follow-Ups:
- Re: autovacuum for large periodic deletes
- From: Chris Browne
- Re: autovacuum for large periodic deletes
- From: Alvaro Herrera
- Re: autovacuum for large periodic deletes
- Prev by Date: Re: does wal archiving block the current client connection?
- Next by Date: Re: autovacuum for large periodic deletes
- Previous by thread: Figuring autovacuum settings
- Next by thread: Re: autovacuum for large periodic deletes
- Indexes: