PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15987
PG Version10.10
OSRHEL
Opened2019-08-31 17:15:10+00
Reported byJo Tzschenscher
StatusNew

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

Messages

DateAuthorSubject
2019-08-31 17:15:10+00PG Bug reporting formBUG #15987: Improve REINDEX of all indexes of a table at once
2019-09-01 04:35:34+00Michael PaquierRe: BUG #15987: Improve REINDEX of all indexes of a table at once
2019-09-01 09:45:50+00Fabien COELHORe: BUG #15987: Improve REINDEX of all indexes of a table at once
2019-09-01 11:18:33+00Jo TzschenscherRe: BUG #15987: Improve REINDEX of all indexes of a table at once
2019-09-01 15:36:25+00Tom LaneRe: BUG #15987: Improve REINDEX of all indexes of a table at once