Re: index question

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: index question
Дата
Msg-id CAKFQuwZCAn47kONL3zxUwH93UEXH4t_FQB4gQ24f7g==Ub2eJg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: index question  (Sameer Kumar <sameer.kumar@ashnik.com>)
Ответы Re: index question  (Sameer Kumar <sameer.kumar@ashnik.com>)
Список pgsql-general
I am not sure, but I think if the size of index is very huge and you suspect they are not being used, you might want to check the bloats percentage in the index. If this is true, perhaps a reindex might help.

If they aren't being used just drop them.  Its when they are used and get bloated that you are in trouble.

There are recipes for bloat calculation out there that are worth investigating.​
 

​David J.​

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

Предыдущее
От: "drum.lucas@gmail.com"
Дата:
Сообщение: Re: Function PostgreSQL 9.2
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Function PostgreSQL 9.2