Re:PostgreSQL 15: Stats Collector Gone? What’s New?
by bluetech on Monday August 29, 2022 @05:34AM
(#32636253)
What advantage does pg_repack have when you only rebuild an index? Or do you mean it has advantage when pg_repack is run on the entire table?
Re:PostgreSQL 15: Stats Collector Gone? What’s New?
by jtc331 on Monday August 29, 2022 @07:43AM
(#32637010)
pg_repack has some significant downsides in its implementation; I question whether it’s really a default over re-indexing concurrently. I’ve certainly not gotten that impression, and we maintain many very large Postgres clusters.
I'm not downplaying the issue and index corruption is really bad, but I would wager a guess that admins who do need concurrent reindexing would also be aware of `pg_repack` and would prefer that anyways because of the other benefits it provides.
This is probably why it took 6 months for the issue to be reported and fixed.