BUG #15987: Improve REINDEX of all indexes of a table at once

The following bug has been logged on the website:

Bug reference: 15987
Logged by: Jo Tzschenscher
Email address: hellojo180(at)yahoo(dot)es
PostgreSQL version: 10.10
Operating system: RHEL
Description:

Hello,

PLEASE ROUTE THIS PROPOSAL TO A DEVELOPMENT TEAM, IT PROPOSES AN IMPROVED
FEATURE.

I am just spending lots of time to rebuild the indexes of our DB one by one,
although all indexes of the same table need a refresh at once, Therefore you
need to open a cursor which contains the DB-columns which occur in at least
one of the indexes. If the same columns occur in more than 1 index you need
to read them only once. Then you run 1 and only 1 full table scan (FTS), and
with the data of the cursor you add an entry into each of the indexes to
rebuild. With just 1 FTS you could create all the indexes at once, and
speeding up a full reindex task to use little more than the time the FTS
takes.

Thank you for listening.

Have a nice day. Cheerio.

Jo