Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Alexandre de Arruda Paes <adaldeia(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows
Date: 2010-08-22 11:35:38
Message-ID: AANLkTikKmWDWNxzmFNGa_b7e+HXN5bh-Z1-PVxxeNs9x@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Aug 21, 2010 at 9:49 AM, Alexandre de Arruda Paes
<adaldeia(at)gmail(dot)com> wrote:
> Only for discussion: the CLUSTER command, in my little knowledge, is a
> intrusive command that's cannot recover the dead tuples too.
>
> Only TRUNCATE can do this job, but obviously is not applicable all the time.

Either VACUUM or CLUSTER will recover *dead* tuples. What you can't
recover are tuples that are still visible to some running transaction.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dimitri 2010-08-22 16:17:23 Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows
Previous Message Alexandre de Arruda Paes 2010-08-21 13:49:25 Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows