Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward
Дата
Msg-id Z-xGsMvMgLYyPfjc@nathan
обсуждение исходный текст
Ответ на Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward  (Dimitrios Apostolou <jimis@gmx.net>)
Ответы Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward
Список pgsql-hackers
On Tue, Apr 01, 2025 at 09:33:32PM +0200, Dimitrios Apostolou wrote:
> It didn't break any test, but I also don't see any difference, the
> performance boost is noticeable only when restoring a huge archive that is
> missing offsets.

This seems generally reasonable to me, but how did you decide on 1MB as the
threshold?  Have you tested other values?  Could the best threshold vary
based on the workload and hardware?

-- 
nathan



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