|
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@xxxxxxxxxxxxxx <pgsql-admin-owner@xxxxxxxxxxxxxx> 代表 xu jian <jamesxu@xxxxxxxxxxx>
发送时间: 2016年12月20日 10:25:23 收件人: pgsql-admin@xxxxxxxxxxxxxx 主题: [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 |
