Re: Add Index-level REINDEX with multiple jobs - Mailing list pgsql-hackers

From Svetlana Derevyanko
Subject Re: Add Index-level REINDEX with multiple jobs
Date
Msg-id 8a65e78b9bb1871ca4508cbf190dfeb4@postgrespro.ru
Whole thread Raw
In response to Re: Add Index-level REINDEX with multiple jobs  ("Andrey M. Borodin" <x4mmm@yandex-team.ru>)
List pgsql-hackers
Andrey M. Borodin писал(а) 2024-03-04 09:26:
>> On 6 Feb 2024, at 11:21, Michael Paquier <michael@paquier.xyz> wrote:
>> 
>> The problem may be actually trickier than that, no?  Could there be
>> other factors to take into account for their classification, like
>> their sizes (typically, we'd want to process the biggest one first, I
>> guess)?
> 
> Maxim, what do you think about it?
> 
> 
> Best regards, Andrey Borodin.

I agree that, as is the case with tables in REINDEX SCHEME, indices 
should be sorted accordingly to their size.

Attaching the second version of patch, with indices being sorted by 
size.

Best regards,
Svetlana Derevyanko
Attachment

pgsql-hackers by date:

Previous
From: Jelte Fennema-Nio
Date:
Subject: Re: Reducing the log spam
Next
From: Bertrand Drouvot
Date:
Subject: Re: Statistics Import and Export