pgsql: Add simple VACUUM progress reporting.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add simple VACUUM progress reporting.
Date: 2016-03-15 17:33:30
Message-ID: E1afsqY-0003qB-Mb@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add simple VACUUM progress reporting.

There's a lot more that could be done here yet - in particular, this
reports only very coarse-grained information about the index vacuuming
phase - but even as it stands, the new pg_stat_progress_vacuum can
tell you quite a bit about what a long-running vacuum is actually
doing.

Amit Langote and Robert Haas, based on earlier work by Vinayak Pokale
and Rahila Syed.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c16dc1aca5e01e6acaadfcf38f5fc964a381dc62

Modified Files
--------------
doc/src/sgml/monitoring.sgml | 207 +++++++++++++++++++++++++++++++++++
src/backend/catalog/system_views.sql | 18 +++
src/backend/commands/vacuumlazy.c | 78 +++++++++++++
src/backend/postmaster/pgstat.c | 29 +++++
src/include/catalog/catversion.h | 2 +-
src/include/commands/progress.h | 37 +++++++
src/include/pgstat.h | 2 +
src/test/regress/expected/rules.out | 22 ++++
8 files changed, 394 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2016-03-15 20:28:28 pgsql: Fix typos.
Previous Message Tom Lane 2016-03-15 17:20:23 pgsql: Cope if platform declares mbstowcs_l(), but not locale_t, in <xl