Re: Table and Index bloating

2017-11-27 Thread stevenchang1213
After reading the web pages, index part should be succeeded, but tables may not fit if they got foreign key relations.  steven  原始訊息 自: Carlos Martinez 日期: 2017/11/27 23:13 (GMT+08:00) 至: pgsql-gene...@postgresql.org 主旨: Re: Table and Index bloating Hi. Can we use pg_repack

Re: Table and Index bloating

2017-11-27 Thread stevenchang1213
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-ge