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

From: Jo Tzschenscher <hellojo180(at)yahoo(dot)es>
To: Michael Paquier <michael(at)paquier(dot)xyz>, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: 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 11:18:33
Message-ID: 1437865225.1016949.1567336713777@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-09-01 15:36:25 Re: BUG #15987: Improve REINDEX of all indexes of a table at once
Previous Message Fabien COELHO 2019-09-01 09:45:50 Re: BUG #15987: Improve REINDEX of all indexes of a table at once