Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]

Поиск
Список
Период
Сортировка
От Dilip kumar
Тема Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]
Дата
Msg-id 4205E661176A124FAF891E0A6BA913526592482E@SZXEML507-MBS.china.huawei.com
обсуждение исходный текст
Ответ на Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]  (Jan Lentfer <Jan.Lentfer@web.de>)
Ответы Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]  (Euler Taveira <euler@timbira.com.br>)
Список pgsql-hackers

On 08 November 2013 13:38, Jan Lentfer

 

> For this use case, would it make sense to queue work (tables) in order of their size, starting on the largest one?

> For the case where you have tables of varying size this would lead to a reduced overall processing time as it prevents large (read: long processing time) tables to be processed in the last step. While processing large tables at first and filling up "processing slots/jobs" when they get free with smaller tables one after the other would safe overall execution time.

Good point, I have made the change and attached the modified patch.

 

 

Regards,

Dilip

Вложения

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

Предыдущее
От: Rajeev rastogi
Дата:
Сообщение: Re: TODO: Split out pg_resetxlog output into pre- and post-sections
Следующее
От: Robert Haas
Дата:
Сообщение: Re: shared memory message queues