agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Fujii Masao <fujii@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Fix index rebuild progress reporting for REPACK (CONCURRENTLY)
Date: Wed, 16 Sep 2026 09:40:17 +0000
Message-ID: <E1x6m7l-00000000ZFc-198c@gemulon.postgresql.org> (raw)
Fix index rebuild progress reporting for REPACK (CONCURRENTLY)
Previously, during REPACK (CONCURRENTLY), index_rebuild_count in
pg_stat_progress_repack and pg_stat_progress_cluster did not advance
as indexes were rebuilt. This made it impossible for users monitoring the
operation to tell how many indexes had been completed.
Fix this by incrementing the count after each index is built on the new
heap, so that both views report the number of completed index builds.
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Álvaro Herrera <alvherre@kurilemu.de>
Discussion: https://postgr.es/m/CAHGQGwFUsrBvTurkSU8TEc=DZTunqteUXrasseqNMT7AMBZKRw@mail.gmail.com
Backpatch-through: 19
Branch
------
REL_19_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/ccbea44294bb3813882052d14a6158302c4b19aa
Modified Files
--------------
src/backend/commands/repack.c | 2 ++
1 file changed, 2 insertions(+)
view thread (3+ messages) latest in thread
Message-ID: <E1x6m7l-00000000ZFc-198c@gemulon.postgresql.org>
Permalink: ../E1x6m7l-00000000ZFc-198c@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1x6m7l-00000000ZFc-198c@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: fujii@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Fix index rebuild progress reporting for REPACK (CONCURRENTLY)
In-Reply-To: <E1x6m7l-00000000ZFc-198c@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox