Re: Report index currently being vacuumed in pg_stat_progress_vacuum

From: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
To: shihao zhong <zhong950419(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Sami Imseih <samimseih(dot)pg(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Sami Imseih <samimseih(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>
Subject: Re: Report index currently being vacuumed in pg_stat_progress_vacuum
Date: 2026-09-18 18:23:37
Message-ID: CALj2ACXsa6vkzsAm885Qvx6xM=Zn8=0=sEwUdfTRGe7vBGFAiw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Thu, Sep 17, 2026 at 6:00 PM shihao zhong <zhong950419(at)gmail(dot)com> wrote:
>
> v7 looks good here. Tested sequential, parallel on btree and GIN, all as the
> docs describe, including GIN reporting zero blocks and the reset
> clearing the previous index. Applies cleanly on 5e595d659fd, suites
> pass.

Thanks for testing v7 on these and for confirming the behavior matches the docs.

> > 0003 and 0004 are not things I can get much into, echoing with the
> > recent following message:
> > https://www.postgresql.org/message-id/aqqmGGS6qqm5LI0Z%40alvherre.pgsql
>
> Thanks for the pointer. I had not seen that thread, withdraw 0003 and 0004.
>
> I will work with Manu and Alvaro on the progress reporting test
> framework in that thread. This patch would make a good first user.

+1 to discussing a general approach for progress reporting tests
separately. We haven't had progress reporting tests so far, but that
doesn't mean we must not have them. One idea is to look at whether
there are any bugs or inconsistencies reported for any of the progress
reporting commands and start from there (but that's a discussion for
the other thread).

--
Bharath Rupireddy
Amazon Web Services: https://aws.amazon.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2026-09-18 18:26:23 Re: Make pg_prewarm, autoprewarm yield for waiting DDL
Previous Message Heikki Linnakangas 2026-09-18 18:15:38 Re: 64-bit MultiXactOffset vs. 9.3->9.4 upgrade, pg_resetwal, "wraparound" msg