Re: When to vacuum a table?

From: Rod Taylor <rod(dot)taylor(at)gmail(dot)com>
To: Steinar H(dot) Gunderson <sgunderson(at)bigfoot(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: When to vacuum a table?
Date: 2006-11-26 14:24:29
Message-ID: 195C9B6B-2018-474C-AA80-239A8CEA37E9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2006-11-26 14:33:52 Re: When to vacuum a table?
Previous Message Marcelo Costa 2006-11-26 13:46:41 Re: When to vacuum a table?