Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward
Date
Msg-id Z-xGsMvMgLYyPfjc@nathan
Whole thread Raw
In response to Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward  (Dimitrios Apostolou <jimis@gmx.net>)
Responses Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Andres Freund
Date:
Subject: TEMP_CONFIG vs test_aio
Next
From: Todd Cook
Date:
Subject: Re: TEMP_CONFIG vs test_aio