The following bug has been logged on the website:
Bug reference: 15987
Logged by: Jo Tzschenscher
Email address: hellojo180@yahoo.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