index bloat estimation

From: Victor Sudakov <vas(at)sibptus(dot)ru>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: index bloat estimation
Date: 2021-02-12 08:26:08
Message-ID: YCY7oPIXobbY8oPu@admin.sibptus.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

--
Victor Sudakov, VAS4-RIPE, VAS47-RIPN
2:5005/49(at)fidonet http://vas.tomsk.ru/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2021-02-12 09:03:36 Re: index bloat estimation
Previous Message Don Seiler 2021-02-11 22:01:29 Re: Managing autovacuum freezing