Re: Reindex vs Vacuum analyze

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reindex vs Vacuum analyze
Дата
Msg-id 14106.1036196733@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reindex vs Vacuum analyze  (Vincent Janelle <random@goblinstudios.com>)
Список pgsql-admin
Vincent Janelle <random@goblinstudios.com> writes:
> when entries are deleted from an table they're not deleted from the
> index, and vacuum doesn't clean them up.

This is entirely false.

There is a problem with recovering space in an index if the range of
indexed values changes over time.  But claiming that we don't delete
index entries is just plain wrong.

            regards, tom lane

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

Предыдущее
От: Naomi Walker
Дата:
Сообщение: Re: loading and unloading rows
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: loading and unloading rows