Re: Table and Index bloating

hello,
https://www.postgresql.org/docs/9.3/static/pgstattuple.html
some enhancements onward
you can try create index concurrent to maintain your index to achieve the goal of reindex. 
Steven 
-------- 原始訊息 --------自： Stefan Fercot <stefan(dot)fercot(at)dalibo(dot)com> 日期： 2017/11/27 17:17 (GMT+08:00) 至： Vikas Sharma <shavikas(at)gmail(dot)com> 副本： pgsql-general(at)postgresql(dot)org 主旨： Re: Table and Index bloating
Hi,

You can track that with some monitoring tools like check_pgactivity. The
queries can be found here :
https://github.com/ioguix/pgsql-bloat-estimation.

Tables :
https://github.com/ioguix/pgsql-bloat-estimation/blob/master/table/table_bloat.sql
Indexes :
https://github.com/ioguix/pgsql-bloat-estimation/blob/master/btree/btree_bloat.sql

Backups should also be part of your maintenance plan.
Vacuum/Analyse/Reindex is already a good basis.

Kind regards

On 11/27/2017 10:10 AM, Vikas Sharma wrote:
> Hi All,
>
> Could someone please provide the query/queries  to find table and
> Index bloating in PgSql 9.3 onwards? 
> and are there any other maintenance tasks inPgSql except vacuum & analyse.
>
> Regards
> Vikas

--
Stefan FERCOT
http://dalibo.com - http://dalibo.org