Re: Add Index-level REINDEX with multiple jobs

Поиск
Список
Период
Сортировка
От Svetlana Derevyanko
Тема Re: Add Index-level REINDEX with multiple jobs
Дата
Msg-id 8a65e78b9bb1871ca4508cbf190dfeb4@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Add Index-level REINDEX with multiple jobs  ("Andrey M. Borodin" <x4mmm@yandex-team.ru>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jelte Fennema-Nio
Дата:
Сообщение: Re: Reducing the log spam
Следующее
От: Bertrand Drouvot
Дата:
Сообщение: Re: Statistics Import and Export