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.fer...@dalibo.com> 日期： 2017/11/27 17:17 (GMT+08:00) 至： Vikas Sharma <shavi...@gmail.com> 副本： pgsql-gene...@postgresql.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
