On Fri, Aug 5, 2011 at 5:26 AM, Tomas Vondra <tv@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