Re: index bloat estimation - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: index bloat estimation
Date
Msg-id CAECtzeXeii2QkYoj4FeKc0BG96Rq_AZEcX8+59_91gU1n-AiCQ@mail.gmail.com
Whole thread Raw
In response to index bloat estimation  (Victor Sudakov <vas@sibptus.ru>)
List pgsql-admin
Hi,

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

pgsql-admin by date:

Previous
From: Victor Sudakov
Date:
Subject: index bloat estimation
Next
From: Keith Fiske
Date:
Subject: Re: index bloat estimation