Collected from the PG bugs email list.
|Reported by||Jo Tzschenscher|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 15987 Logged by: Jo Tzschenscher Email address: (redacted) 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
|2019-08-31 17:15:10+00||PG Bug reporting form||BUG #15987: Improve REINDEX of all indexes of a table at once|
|2019-09-01 04:35:34+00||Michael Paquier||Re: BUG #15987: Improve REINDEX of all indexes of a table at once|
|2019-09-01 09:45:50+00||Fabien COELHO||Re: BUG #15987: Improve REINDEX of all indexes of a table at once|
|2019-09-01 11:18:33+00||Jo Tzschenscher||Re: BUG #15987: Improve REINDEX of all indexes of a table at once|
|2019-09-01 15:36:25+00||Tom Lane||Re: BUG #15987: Improve REINDEX of all indexes of a table at once|