parallel pg_restore blocks on heavy random read I/O on all children processes

Hello list, I noticed the weird behaviour that doing a pg_restore of a huge database dump, leads to constant read I/O (at about 15K IOPS from the NVMe drive that has the dump file) for about one hour. I believe it happens with any -j value>=2. In particular, I get output like the following in th

Re: parallel pg_restore blocks on heavy random read I/O on all children processes

Dimitrios Apostolou writes: > I noticed the weird behaviour that doing a pg_restore of a huge database > dump, leads to constant read I/O (at about 15K IOPS from the NVMe drive > that has the dump file) for about one hour. I believe it happens with > any -j value>=2. > In particular, I get output