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.