Re: when to reindex?

Поиск
Список
Период
Сортировка
От Jeremy Harris
Тема Re: when to reindex?
Дата
Msg-id 484A9D18.2080103@wizmail.org
обсуждение исходный текст
Ответ на Re: when to reindex?  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: when to reindex?
Список pgsql-general
Gregory Stark wrote:
>  REINDEX scans the table
> precisely once and sorts it.

For the bloat, as opposed to corruption, case -
what information is needed from the table that
is not in the old index?  Why would a sequential
read of the old index alone (then some processing)
not suffice?

Thanks,
   Jeremy Harris

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