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