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 日期: 2017/11/27 17:17 (GMT+08:00) 至: Vikas Sharma 副本: pgsql-general@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