On Fri, Aug 5, 2011 at 5:26 AM, Tomas Vondra <t...@fuzzy.cz> wrote: > On 5 Srpen 2011, 10:52, Vivekkumar Pandey wrote: > >> Also suggest the Query that can view the dead tuples in the table. > > You can't see the dead tuples with a query - that's why they're called > dead.
you can see an estimate of how many dead tuples are looking at the n_dead_tup in pg_stat_all_tables -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
