Quick Links

questions about a table's row estimates

From:	Ben Chobot <bench(at)silentmedia(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	questions about a table's row estimates
Date:	2010-02-05 20:14:09
Message-ID:	365BD76B-0B81-46EC-B951-61214A30DE96@silentmedia.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

I'm looking at pg_stat_user_tables in 8.4.2, and I'm confused about n_live_tup. Shouldn't that be at least fairly close to (n_tup_ins - n_tup-del)? It doesn't seem to be, but I'm unclear why.

Responses

Re: questions about a table's row estimates at 2010-02-09 05:08:52 from Ben Chobot
Re: questions about a table's row estimates at 2010-02-11 06:28:10 from Greg Smith

Browse pgsql-general by date

	From	Date	Subject
Next Message	Sebastian Hennebrueder	2010-02-05 20:19:40	Re: PostgreSQL + Hibernate, Apache Mod Security, SQL Injection and you (a love story)
Previous Message	John R Pierce	2010-02-05 20:09:57	Re: PostgreSQL + Hibernate, Apache Mod Security, SQL Injection and you (a love story)