On Sat, Aug 21, 2010 at 9:49 AM, Alexandre de Arruda Paes <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
