From: | xu jian <jamesxu(at)outlook(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | 答复: Does special index type have index bloat issue? for instance gist, gin, brin? |
Date: | 2016-12-20 15:33:57 |
Message-ID: | MWHPR20MB14219C58A5655E7202691ED1A1900@MWHPR20MB1421.namprd20.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am sorry, the previous email is a draft, and sent by accident [☹]
Hello,
I am looking for a script to show index bloat status, I come cross Josh's script https://github.com/pgexperts/pgx_scripts/blob/master/bloat/index_bloat_check.sql
it looks like the script only checking btree index bloating. Does other type index have bloat issue? for instance gist, gin, brin? do I need to rebuild those type of index?
I also find another script http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html, which is better for checking index bloat? thanks
James
________________________________
发件人: pgsql-admin-owner(at)postgresql(dot)org <pgsql-admin-owner(at)postgresql(dot)org> 代表 xu jian <jamesxu(at)outlook(dot)com>
发送时间: 2016年12月20日 10:25:23
收件人: pgsql-admin(at)postgresql(dot)org
主题: [ADMIN] Does special index type have index bloat issue? for instance gist, gin, brin?
Hello,
I am looking for a script to show index bloat status, I come cross
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2016-12-20 20:17:42 | Lock a viewe |
Previous Message | xu jian | 2016-12-20 15:25:23 | Does special index type have index bloat issue? for instance gist, gin, brin? |