On Sat, Aug 21, 2010 at 9:49 AM, Alexandre de Arruda Paes
<adaldeia@gmail.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