Jeremy Harris wrote:
> Simon Riggs wrote:
>> The idea of auto rebuilding indexes following recovery has already been
>> proposed, so is under consideration. It hasn't been proposed in relation
>> to the use case you mention, so that is new.
>>
>> If we did as you suggest then it would speed up the base backup but
>> would also add index rebuild time onto the end of any recovery.
>
> Forgive me for being stupid, but isn't a time when all the data for
> a table is being streamed in, during restore, the *perfect* time
> to build an index? Why wait until after the restore?
Not all the data streams in. Most of it is there before the WAL replay
begins.
-Glen