Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: When to vacuum a table?
- From: Rod Taylor <rod(dot)taylor(at)gmail(dot)com>
- To: Steinar H. Gunderson <sgunderson(at)bigfoot(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: When to vacuum a table?
- Date: Sun, 26 Nov 2006 09:24:29 -0500
On 26-Nov-06, at 8:11 AM, Steinar H. Gunderson wrote:
On Sun, Nov 26, 2006 at 09:43:11AM -0300, Marcelo Costa wrote:All its tables constantly manipulated (INSERT, UPDATE, DELETE) they need aVACUUMJust a minor clarification here: INSERT does not create dead rows, only UPDATE and DELETE do. Thus, if you only insert rows, you do not need tovacuum (although you probably need to analyze).
Not entirely true. An insert & rollback will create dead rows. If you attempt and fail a large number of insert transactions then you will still need to vacuum.
- Follow-Ups:
- Re: When to vacuum a table?
- From: Craig A. James
- Re: When to vacuum a table?
- From: Andrew Sullivan
- Re: When to vacuum a table?
- References:
- When to vacuum a table?
- From: Joost Kraaijeveld
- Re: When to vacuum a table?
- From: Marcelo Costa
- Re: When to vacuum a table?
- From: Steinar H. Gunderson
- When to vacuum a table?
- Prev by Date: Re: When to vacuum a table?
- Next by Date: Re: When to vacuum a table?
- Previous by thread: Re: When to vacuum a table?
- Next by thread: Re: When to vacuum a table?
- Indexes: