index bloat estimation - Mailing list pgsql-admin

From Victor Sudakov
Subject index bloat estimation
Date
Msg-id YCY7oPIXobbY8oPu@admin.sibptus.ru
Whole thread Raw
Responses Re: index bloat estimation  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: index bloat estimation  (Keith Fiske <keith.fiske@crunchydata.com>)
Re: index bloat estimation  (Gregory Smith <gregsmithpgsql@gmail.com>)
List 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@fidonet http://vas.tomsk.ru/



pgsql-admin by date:

Previous
From: Don Seiler
Date:
Subject: Re: Managing autovacuum freezing
Next
From: Guillaume Lelarge
Date:
Subject: Re: index bloat estimation