[ADMIN] 答复: Does special index type have index bloat issue? for instance gist, gin, brin?

Поиск
Список
Период
Сортировка
От xu jian
Тема [ADMIN] 答复: Does special index type have index bloat issue? for instance gist, gin, brin?
Дата
Msg-id MWHPR20MB14219C58A5655E7202691ED1A1900@MWHPR20MB1421.namprd20.prod.outlook.com
обсуждение исходный текст
Ответ на [ADMIN] Does special index type have index bloat issue? for instance gist,gin, brin?  (xu jian <jamesxu@outlook.com>)
Список 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@postgresql.org <pgsql-admin-owner@postgresql.org> 代表 xu jian <jamesxu@outlook.com>
发送时间: 2016年12月20日 10:25:23
收件人: pgsql-admin@postgresql.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 

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: xu jian
Дата:
Сообщение: [ADMIN] Does special index type have index bloat issue? for instance gist,gin, brin?
Следующее
От: Gaetano Mendola
Дата:
Сообщение: [ADMIN] Lock a viewe