Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres table have a large number of relpages and occupied a big memory size - Mailing list pgsql-general

From Jaime Casanova
Subject Re: postgres table have a large number of relpages and occupied a big memory size
Date
Msg-id CAJKUy5jYFZj4J7quiuwzqs+wbqR=PbuPnVqH9xjMqJBAefTX8w@mail.gmail.com
Whole thread Raw
In response to Re: postgres table have a large number of relpages and occupied a big memory size  ("Tomas Vondra" <tv@fuzzy.cz>)
Responses Re: postgres table have a large number of relpages and occupied a big memory size
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: using raise info to display array element
Next
From: Rob Sargent
Date:
Subject: post installation addition of uuid extension