Re: index growth

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: index growth
Дата
Msg-id 9137.1144598878@sss.pgh.pa.us
обсуждение исходный текст
Ответ на index growth  (Alex Mayrhofer <axelm@nona.net>)
Ответы Re: index growth  (Alex Mayrhofer <axelm@nona.net>)
Список pgsql-general
Alex Mayrhofer <axelm@nona.net> writes:
> i have a bunch of indices over rather frequently updated large tables. Those
> indices grow in size with the updates, so i frequently re-index them.

That usually shouldn't be necessary since PG 7.4 or so.  Do you have
some strange pattern of index key usage that is triggering index bloat,
or is this just a habit leftover from pre-7.4?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )
Следующее
От: Gavin Hamill
Дата:
Сообщение: Re: Load testing across 2 machines