I'd love to see this back patched into 8.2.1 if possible.
Should I resubmit with new names?
-Glen
Bruce Momjian wrote:
Is this something we want in 8.3? I am thinking visible/expired would
be clearer terms.
---------------------------------------------------------------------------
Glen Parker wrote:
This patch consists of two c functions to expose n_live_tuples and
n_dead_tuples, SQL functions to expose them to SQL land, and
corresponding fields added to pg_stat_all_tables.
This has been discussed in general. The purpose is to allow
autovacuum-esq conditional vacuuming and clustering using SQL to
discover the required stats.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
