Re: Table and Index bloating

[stevenchang1213 <stevenchang1213@xxxxxxxxx>]

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.fercot@xxxxxxxxxx>

日期： 2017/11/27 17:17 (GMT+08:00)

至： Vikas Sharma <shavikas@xxxxxxxxx>

副本： pgsql-general@xxxxxxxxxxxxxx

主旨： 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