Re: Big index sizes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Big index sizes
Дата
Msg-id 15381.1230651561@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Big index sizes  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-performance
Guillaume Lelarge <guillaume@lelarge.info> writes:
> Laszlo Nagy a �crit :
>> We have serveral table where the index size is much bigger than the
>> table size.
>> ...
>> Vacuuming a table does not rebuild the indexes, am I right?

> Neither VACUUM nor VACUUM FULL rebuild the indexes. CLUSTER and REINDEX do.

In fact, VACUUM FULL tends to make indexes *more* bloated not less so.
One fairly likely explanation for how you got into this situation is
overeager use of VACUUM FULL.

            regards, tom lane

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

Предыдущее
От: "Robert Haas"
Дата:
Сообщение: Re: perform 1 check vs exception when unique_violation
Следующее
От: bricklen
Дата:
Сообщение: Poor plan choice in prepared statement