| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | hellojo180(at)yahoo(dot)es, PostgreSQL Bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15987: Improve REINDEX of all indexes of a table at once |
| Date: | 2019-09-01 09:45:50 |
| Message-ID: | alpine.DEB.2.21.1909011143230.29429@lancre |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jo Tzschenscher | 2019-09-01 11:18:33 | Re: BUG #15987: Improve REINDEX of all indexes of a table at once |
| Previous Message | Michael Paquier | 2019-09-01 04:35:34 | Re: BUG #15987: Improve REINDEX of all indexes of a table at once |