pgsql: Add progress reporting for CLUSTER and VACUUM FULL.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add progress reporting for CLUSTER and VACUUM FULL.
Date: 2019-03-25 15:02:42
Message-ID: E1h8R7a-0000U8-Ng@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add progress reporting for CLUSTER and VACUUM FULL.

This uses the same progress reporting infrastructure added in commit
c16dc1aca5e01e6acaadfcf38f5fc964a381dc62 and extends it to these
additional cases. We lack the ability to track the internal progress
of sorts and index builds so the information reported is
coarse-grained for some parts of the operation, but it still seems
like a significant improvement over having nothing at all.

Tatsuro Yamada, reviewed by Thomas Munro, Masahiko Sawada, Michael
Paquier, Jeff Janes, Alvaro Herrera, Rafia Sabih, and by me. A fair
amount of polishing also by me.

Discussion: http://postgr.es/m/59A77072.3090401@lab.ntt.co.jp

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/6f97457e0ddd8b421ca5e483439ef0318e6fc89a

Modified Files
--------------
doc/src/sgml/monitoring.sgml | 199 +++++++++++++++++++++++++++++++++--
src/backend/catalog/index.c | 9 ++
src/backend/catalog/system_views.sql | 27 +++++
src/backend/commands/cluster.c | 88 ++++++++++++++++
src/backend/utils/adt/pgstatfuncs.c | 2 +
src/include/catalog/catversion.h | 2 +-
src/include/commands/progress.h | 23 ++++
src/include/pgstat.h | 3 +-
src/test/regress/expected/rules.out | 28 +++++
9 files changed, 373 insertions(+), 8 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2019-03-25 15:18:13 pgsql: pgbench: Remove \cset
Previous Message Alexander Korotkov 2019-03-25 12:58:12 Re: pgsql: Get rid of backtracking in jsonpath_scan.l