Horton

Re: progress reporting for partitioned REINDEX

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>, pgsql-hackers@lists.postgresql.org, Anastasia Lubennikova <a.lubennikova@postgrespro.ru>, Alvaro Herrera <alvherre@2ndquadrant.com>
Date: 2021-02-20T01:37:08Z
Lists: pgsql-hackers 
On Fri, Feb 19, 2021 at 12:12:54AM -0600, Justin Pryzby wrote:
> Looks fine.

Thanks, applied then to clarify things.

> Also, I noticed that vacuum recurses into partition heirarchies since v10, but
> pg_stat_progress_vacuum also doesn't show anything about the parent table or
> the progress of recursing through the hierarchy.

Yeah, that's an area where it would be possible to improve the
monitoring, for both autovacuums and manual VACUUMs.
--
Michael

Commits

  1. doc: Mention that partitions_{done,total} is 0 for REINDEX progress reports