Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tyKNg-005CyZ-8U for pgsql-performance@arkaria.postgresql.org; Sat, 29 Mar 2025 00:49:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tyKNe-001tZO-GF for pgsql-performance@arkaria.postgresql.org; Sat, 29 Mar 2025 00:48:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tyKNe-001tZG-5x for pgsql-performance@lists.postgresql.org; Sat, 29 Mar 2025 00:48:58 +0000 Received: from mout.gmx.net ([212.227.15.19]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tyKNb-001ndg-2u for pgsql-performance@lists.postgresql.org; Sat, 29 Mar 2025 00:48:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1743209330; x=1743814130; i=jimis@gmx.net; bh=ROFwfUo46rRIawTYG+HwxDwXZLdWPB1wgpu47Fa373Y=; h=X-UI-Sender-Class:Date:From:To:cc:Subject:In-Reply-To:Message-ID: References:MIME-Version:Content-Type:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=Zgs6cF0iKqIYhqjD//7BPS9GhQuAs7KdEXLVO2egf0eaz+1MthxrlTfa4sDYw202 QEleHKCVxXOPkY7yndfbymn5lMTW4fruk4wCWswxQoBU62Zw0uaUFnvfcRmUKaEKa LJkELN3QCyyNjVOs+eJ0jzl27mgwy7ntsfFs4gopOXnHVQsLnXxJjZHkl+cJxzSie w3FzGU9YamFP9pjzl2ZT8xe3+MGSkOFC1SAlA2MK3GHv+41N3GmO28JvnWJ15v12z yZ1hJO1HJcXXM/0t+dX2Wtcm1/3QR76+v+ojvGUhjQGjWU7+kAreoWGoEwFFzsmhl /Xlq1iSFqWVE4PsNfQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.81] ([185.55.106.54]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1M6lpM-1u3IzM0rLq-000qSZ; Sat, 29 Mar 2025 01:48:50 +0100 Date: Sat, 29 Mar 2025 01:48:49 +0100 (CET) From: Dimitrios Apostolou To: Tom Lane cc: pgsql-performance@lists.postgresql.org Subject: Re: parallel pg_restore blocks on heavy random read I/O on all children processes In-Reply-To: <1cbb9bd6-60cd-92cb-c3c2-4cf4fd8a7b64@gmx.net> Message-ID: <682d97f8-9227-e4ee-89b7-bc23aaf95974@gmx.net> References: <6bd16bdb-aa5e-0512-739d-b84100596035@gmx.net> <1095774.1742498237@sss.pgh.pa.us> <556498.1742744802@sss.pgh.pa.us> <3764bde7-ca09-a8a3-489c-0166f772245d@gmx.net> <1cbb9bd6-60cd-92cb-c3c2-4cf4fd8a7b64@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset=US-ASCII X-Provags-ID: V03:K1:RPijacEwUZ0yHwHGthmHZLsJbgrMqdUQ+8oN5dPOAWYM14WIjoq yfZ33le0DMFXhEQB+YL3Lh2mGGgzRhLs1i47XsY5iOZ5NQocfRAp+11Acx2gGNEx0ha7k13 rNR4n/lAb9EOYdIZM8W9fm6nhYxw0Mi8nxL7SOBeFvwsbkcvdWywIGsqwz1u+yp4fZj/sTd 25XOOUGx+Ovd61XQ7Uwhw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:u8VUDJoZrDg=;CLDVnK2vcFoKB6rP6yFtqxoeD/s pmoliVtjCQGY5y4I+3/cj8hKFrs03Dg01kXy3jYlK4vZ+J6mytfhzLKFFn1AAcoNrws/g+h+E u5oZSn9uuGvzYJhv8nMBxKhLxI2tn2AuSGKeQ1gkbTCztuobArrhD+d+7cHth/llRRlBCnmEf mEMrPOEIQ/kinsV6Iq6EFrpZ0kMjnyn9h6lsdsXET1dT8MeRjzjtHpnE8stJVEmH4igOX2yMf Ku59AbP7cIK4YvHfIJmaXDtsFbt7uLq7k7GAWri6Bn8QpR0zwNh2Eh015omiK8EZ8uHtXHwn1 dDkUbnev2isDQUdsRrrF7nQeocLeo2060db0KFCQLm25xByPQaZv919z8cOsA/F2cagdl+DCU kwRkATAVFxaHT0xdaEGrdxgRHKkZw0DyB1NYWJHreQtT7bOfYquS3MipTotd1bNCzlOn7uXRv AQtAjPeNB+BGrS5b/jsDiV/nikc9Mn2B+yfZxYHwQzfIhfTE7MCGWGUBleBWjdtpDi5jedAcK cEHVmIaVpc5jpHBNfQN0e2tWsprLSG5CvU/RKyRKSkv45Q+sor+JisSyRERfgAs1XsBmPh7Ey gjOyvLur3gWP+Fd2a8RWqrc9KkktDtVUqwkDoYPTXeMTRi/v2usYvoNea2v4L41AA+7KHXhWh xlQaQiQ9mrZGg9c/D9/AohxUpmYc2YCtdgILns2zObjCF9oCzqQ7nThx0MALKuEeF/6SuffNu K160ClCS+hPHr507oBVM0fikVxoMhdVzusiWlSVvzw9uj1OOtbammgzwM3v06z52RgkugMPNX zAJ1GcGalFEd0xxAFYQTZY1oD2k0x9JhioZrvO0UGlEgsEJLpoOSR/ddQDIFDXYvC9K42YJXi Nd7y6JUXOCt/zGSUwyiPa6T1DPIVEDsBABd1vpVnOSxUeiNmBWnp2D5PBiHae+O7NRdqMaQen 9V0U/OYhleXR82ZD6eewm+DtxuC223HxdjWhBsGDYkzU+wqMvRwz7ElfsILQU3bsOpPCr0ast iQM4DCISGpBgdo6Te89ivfWUlonVfgWV2wbV4yltPwqJCwN9hwJrM9TNfYzSadJIVjP0+CfX/ 1ZKsfSLoJT5eUoad3EhurwUwns8EC+ErYryFgRZf//feW93/HN2GzS4pvQWlIfG8AJH6N/D6m hZoSE3COvlKc+VJFMuaNQ8xys94R+P2Han1obIUVmgFpgW6zbiBsNTFG1srHX8S21QJh2f6Un vydRI+E7sqmSLq4tvuAA64J/MpaUh3F6OPzmVcVWIeXJnnRwVLdJ2s0zPYeATgzJwMMCamjyX iGFYZDg7NWSTfD3xc2iWuaBPfDyPezEQtEnz2t64ujmjjgFOZml58LlaFixzLbIbDtR0rhNXM FdwqB8eThr2HfHe3BZtBb7VO1r/HRrVkoJEJMDac+6AHa4beDk0EuXhbfa2hBjhS6qf7JFs8/ zzn1BAA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Sent proper patch to pgsql-hackers mailing list, at: https://www.postgresql.org/message-id/flat/2edb7a57-b225-3b23-a680-62ba90658fec%40gmx.net