Re: BUG #15987: Improve REINDEX of all indexes of a table at once

Поиск
Список
Период
Сортировка
От Jo Tzschenscher
Тема Re: BUG #15987: Improve REINDEX of all indexes of a table at once
Дата
Msg-id 1437865225.1016949.1567336713777@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: BUG #15987: Improve REINDEX of all indexes of a table at once  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-bugs
Дерево обсуждения
Totally correct, Fabien!



En domingo, 1 de septiembre de 2019 11:45:57 CEST, Fabien COELHO <coelho@cri.ensmp.fr> escribió:




>> one of the indexes. If the same columns occur in more than 1 index you need
>> to read them only once. Then you run 1 and only 1 full table scan (FTS), and
>> with the data of the cursor you add an entry into each of the indexes to
>> rebuild. With just 1 FTS you could create all the indexes at once, and
>> speeding up a full reindex task to use little more than the time the FTS
>> takes.
>
> I don't quite understand your request.  You have REINDEX TABLE which
> is able to reindex all the indexes of a table one by one, […]


I understood the request as the scan should be factored out, so that
reindexing a table with multiple indexes would cost only one seq scan.

--
Fabien.

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

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: BUG #15987: Improve REINDEX of all indexes of a table at once
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15987: Improve REINDEX of all indexes of a table at once