Re: index bloat estimation

Hi,

Le ven. 12 févr. 2021 à 09:26, Victor Sudakov <vas(at)sibptus(dot)ru> 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.