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

From Dimitrios Apostolou
Subject Re: [PATCH v4] parallel pg_restore: avoid disk seeks when jumping short distance forward
Date
Msg-id 7B29E5B2-94DC-48ED-A1F3-247BCE5A2329@gmx.net
Whole thread Raw
In response to Re: [PATCH v4] parallel pg_restore: avoid disk seeks when jumping short distance forward  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH v4] parallel pg_restore: avoid disk seeks when jumping short distance forward
List pgsql-hackers
Thanks for the extensive testing! Did you see the same syscall pattern in strace output, as I did?

If yes, then the only reason I can think of that excuses the regression with my patch is that the SATA interface was
maxedout when reading sequentially, while the very short latency of SSDs guarantees thousands of seek() operations per
second.

I was using an HDD, and in older measurements I was using a VM with mounted volume over iSCSI. The first imposes
physicallimits in the amount of seeks, and the second network round-trip limits. 

So you are right, it's probably very platform dependent, and the most important fix was to enlarge the underlying block
size,that you have done. 


Dimitris



pgsql-hackers by date:

Previous
From: John H
Date:
Subject: Re: Making pg_rewind faster
Next
From: Tom Lane
Date:
Subject: Re: [PATCH v4] parallel pg_restore: avoid disk seeks when jumping short distance forward