pgsql: Add progress reporting to pg_checksums

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add progress reporting to pg_checksums
Date: 2019-04-02 02:04:53
Message-ID: E1hB8nF-0005i9-I2@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add progress reporting to pg_checksums

This adds a new option to pg_checksums called -P/--progress, showing
every second some information about the computation state of an
operation for --check and --enable (--disable only updates the control
file and is quick). This requires a pre-scan of the data folder so as
the total size of checksummable items can be calculated, and then it
gets compared to the amount processed.

Similarly to what is done for pg_rewind and pg_basebackup, the
information printed in the progress report consists of the current
amount of data computed and the total amount of data to compute. This
could be extended later on.

Author: Michael Banck, Bernd Helmle
Reviewed-by: Fabien Coelho, Michael Paquier
Discussion: https://postgr.es/m/1535719851.1286.17.camel@credativ.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/280e5f14056bf34a0f52320f659fb93acfda0876

Modified Files
--------------
doc/src/sgml/ref/pg_checksums.sgml | 11 ++++
src/bin/pg_checksums/pg_checksums.c | 114 +++++++++++++++++++++++++++++++++---
2 files changed, 117 insertions(+), 8 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Dean Rasheed 2019-04-02 07:31:44 pgsql: Perform RLS subquery checks as the right user when going via a v
Previous Message Thomas Munro 2019-04-02 01:47:11 pgsql: Add wal_recycle and wal_init_zero GUCs.