Re: Add index scan progress to pg_stat_progress_vacuum - Mailing list pgsql-hackers

From Bossart, Nathan
Subject Re: Add index scan progress to pg_stat_progress_vacuum
Date
Msg-id 6067E1B3-07E6-478D-9A6B-B62F5D641EF2@amazon.com
Whole thread Raw
In response to Re: Add index scan progress to pg_stat_progress_vacuum  ("Imseih (AWS), Sami" <simseih@amazon.com>)
List pgsql-hackers
On 1/11/22, 12:33 PM, "Imseih (AWS), Sami" <simseih@amazon.com> wrote:
> What about something like  "The number of indexes that are eligible for vacuuming".
> This covers the cases where either an individual index is skipped or the entire "index vacuuming" phase is skipped.

Hm.  I don't know if "eligible" is the right word.  An index can be
eligible for vacuuming but skipped because we set INDEX_CLEANUP to
false.  Maybe we should just stick with "The number of indexes that
will be vacuumed."  The only thing we may want to clarify is whether
this value will change in some cases (e.g., vacuum failsafe takes
effect).

Nathan


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Windows crash / abort handling
Next
From: Tom Lane
Date:
Subject: Re: [EXTERNAL] Re: PQcancel does not use tcp_user_timeout, connect_timeout and keepalive settings