pgsql: Allow the pgstat views to show toast tables as well as regular

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow the pgstat views to show toast tables as well as regular
Date: 2005-08-15 16:25:19
Message-ID: 20050815162519.8FE9152ADA@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Allow the pgstat views to show toast tables as well as regular tables
(the stats system has always collected this info, but the views were
filtering it out). Modify autovacuum so that over-threshold activity
in a toast table can trigger a VACUUM of the parent table, even if the
parent didn't appear to need vacuuming itself. Per discussion a month
or so back about "short, wide tables".

Modified Files:
--------------
pgsql/src/backend/catalog:
system_views.sql (r1.19 -> r1.20)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql.diff?r1=1.19&r2=1.20)
pgsql/src/backend/postmaster:
autovacuum.c (r1.3 -> r1.4)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/autovacuum.c.diff?r1=1.3&r2=1.4)
pgstat.c (r1.105 -> r1.106)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgstat.c.diff?r1=1.105&r2=1.106)
pgsql/src/include/catalog:
catversion.h (r1.298 -> r1.299)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.298&r2=1.299)
pgsql/src/include:
pgstat.h (r1.35 -> r1.36)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/pgstat.h.diff?r1=1.35&r2=1.36)
pgsql/src/test/regress/expected:
rules.out (r1.106 -> r1.107)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.106&r2=1.107)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2005-08-15 19:05:16 pgsql: int_array_enum function should be using fcinfo->flinfo->fn_extra
Previous Message Tom Lane 2005-08-15 02:40:37 pgsql: Clean up some stray remaining references to pg_shadow, pg_user,