Re: Add index scan progress to pg_stat_progress_vacuum

Sami Imseih <simseih@amazon.com>

From: "Imseih (AWS), Sami" <simseih@amazon.com>

To: Masahiko Sawada <sawada.mshk@gmail.com>, Nathan Bossart <nathandbossart@gmail.com>

Cc: Peter Geoghegan <pg@bowt.ie>, "Bossart, Nathan" <bossartn@amazon.com>, Justin Pryzby <pryzby@telsasoft.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2022-03-16T21:47:49Z

Lists: pgsql-hackers

Attachments

v9-0001-Add-infrastructure-for-parallel-progress-reporting.patch (application/octet-stream) patch v9-0001
v9-0002-Show-progress-for-index-vacuums.patch (application/octet-stream) patch v9-0002
v9-0003-Expose-indexes-being-processed-in-a-VACUUM-operat.patch (application/octet-stream) patch v9-0003
v9-0004-Rename-index_vacuum_count-in-pg_stat_pogress_vacu.patch (application/octet-stream) patch v9-0004

Spoke to Nathan offline and fixed some more comments/nitpicks in the patch.

Commits

Report index vacuum progress.
- 46ebdfe164c6 17.0 landed
Add new parallel message type to progress reporting.
- f1889729dd3a 17.0 landed
Remove MaxBackends variable in favor of GetMaxBackends() function.
- aa64f23b0292 15.0 cited