pgsql: Add n_live_tuples and n_dead_tuples to pg_stat_all_tables.

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add n_live_tuples and n_dead_tuples to pg_stat_all_tables.
Date: 2007-01-02 20:59:32
Message-ID: 20070102205932.EF8E89FA440@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Add n_live_tuples and n_dead_tuples to pg_stat_all_tables.

The purpose is to allow autovacuum-esq conditional vacuuming and
clustering using SQL to discover the required stats.

No documentation updates required. Catalog version updated.

Glen Parker

Modified Files:
--------------
pgsql/src/backend/catalog:
system_views.sql (r1.33 -> r1.34)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql.diff?r1=1.33&r2=1.34)
pgsql/src/backend/utils/adt:
pgstatfuncs.c (r1.35 -> r1.36)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/pgstatfuncs.c.diff?r1=1.35&r2=1.36)
pgsql/src/include/catalog:
catversion.h (r1.368 -> r1.369)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.368&r2=1.369)
pg_proc.h (r1.434 -> r1.435)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h.diff?r1=1.434&r2=1.435)
pgsql/src/test/regress/expected:
rules.out (r1.123 -> r1.124)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.123&r2=1.124)

Browse pgsql-committers by date

  From Date Subject
Next Message User Okbob 2007-01-02 21:03:07 plpsm - plpgpsm: Refactoring declaration of variables, cursors and
Previous Message Bruce Momjian 2007-01-02 20:50:35 pgsql: Add #include <float.h> for platforms that still need it.