Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group