Quick Links

Re: postgres table have a large number of relpages and occupied a big memory size

From:	Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To:	Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc:	Vivekkumar Pandey <vivekkumar(dot)pandey(at)globallogic(dot)com>, pgsql-general(at)postgresql(dot)org
Subject:	Re: postgres table have a large number of relpages and occupied a big memory size
Date:	2011-08-05 18:42:57
Message-ID:	CAJKUy5jYFZj4J7quiuwzqs+wbqR=PbuPnVqH9xjMqJBAefTX8w@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

In response to

Re: postgres table have a large number of relpages and occupied a big memory size at 2011-08-05 10:26:49 from Tomas Vondra

Responses

Re: postgres table have a large number of relpages and occupied a big memory size at 2011-08-08 06:02:08 from Vivekkumar Pandey

Browse pgsql-general by date

	From	Date	Subject
Next Message	Rob Sargent	2011-08-05 21:55:43	post installation addition of uuid extension
Previous Message	Pavel Stehule	2011-08-05 18:27:32	Re: using raise info to display array element