On Sat, Aug 21, 2010 at 9:49 AM, Alexandre de Arruda Paes <adaldeia@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
