index bloat estimation

Поиск
Список
Период
Сортировка
От Victor Sudakov
Тема index bloat estimation
Дата
Msg-id YCY7oPIXobbY8oPu@admin.sibptus.ru
обсуждение
Ответы Re: index bloat estimation
Re: index bloat estimation
Re: index bloat estimation
Список 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 по дате отправления: