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

Totally correct, Fabien!

En domingo, 1 de septiembre de 2019 11:45:57 CEST, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)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.