pgsql: Add n_live_tuples and n_dead_tuples to pg_stat_all_tables. - Mailing list pgsql-committers

From momjian@postgresql.org (Bruce Momjian)
Subject pgsql: Add n_live_tuples and n_dead_tuples to pg_stat_all_tables.
Date
Msg-id 20070102205932.EF8E89FA440@postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add #include for platforms that still need it.
Next
From: okbob@pgfoundry.org (User Okbob)
Date:
Subject: plpsm - plpgpsm: Refactoring declaration of variables, cursors and