Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: When to vacuum a table?
- From: "Steinar H. Gunderson" <sgunderson(at)bigfoot(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: When to vacuum a table?
- Date: Sun, 26 Nov 2006 14:11:47 +0100
On Sun, Nov 26, 2006 at 09:43:11AM -0300, Marcelo Costa wrote: > All its tables constantly manipulated (INSERT, UPDATE, DELETE) they need a > VACUUM Just 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 to vacuum (although you probably need to analyze). /* Steinar */ -- Homepage: http://www.sesse.net/
- Follow-Ups:
- Re: When to vacuum a table?
- From: Rod Taylor
- Re: When to vacuum a table?
- From: Marcelo Costa
- Re: When to vacuum a table?
- References:
- When to vacuum a table?
- From: Joost Kraaijeveld
- Re: When to vacuum a table?
- From: Marcelo Costa
- 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: