Re: BUG #15987: Improve REINDEX of all indexes of a table at once
От | Fabien COELHO |
---|---|
Тема | Re: BUG #15987: Improve REINDEX of all indexes of a table at once |
Дата | |
Msg-id | alpine.DEB.2.21.1909011143230.29429@lancre обсуждение исходный текст |
Ответ на | Re: BUG #15987: Improve REINDEX of all indexes of a table at once (Michael Paquier <michael@paquier.xyz>) |
Ответы |
Re: BUG #15987: Improve REINDEX of all indexes of a table at once
Re: BUG #15987: Improve REINDEX of all indexes of a table at once |
Список | pgsql-bugs |
>> 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 по дате отправления: