Hi,
Le ven. 12 févr. 2021 à 09:26, Victor Sudakov <vas@xxxxxxxxxx> a écrit :
Dear Colleagues,
What queries do you use to estimate index and table bloat?
I've researched some on the Net and found multiple scripts mentioned in
https://wiki.postgresql.org/wiki/Index_Maintenance#Index_Bloat, also
in https://github.com/pgexperts/pgx_scripts etc.
Most of the stuff I've looked at is pretty old, much seems unsupported.
What is the current best practice?
I'd be grateful if you could share your personal favourite ways of
estimating bloat.
I use https://github.com/ioguix/pgsql-bloat-estimation . It's pretty good at estimating bloat on tables and Btree indexes (though deduplication in v13 makes it harder).
check_pgactivitu uses the queries from this repository.
--
Guillaume.
