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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: parallel pg_restore blocks on heavy random read I/O on all children processes
From: Dimitrios Apostolou <jimis@xxxxxxx>
Date: Sat, 29 Mar 2025 01:48:49 +0100 (CET)
Cc: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <1cbb9bd6-60cd-92cb-c3c2-4cf4fd8a7b64@gmx.net>
References: <6bd16bdb-aa5e-0512-739d-b84100596035@gmx.net> <1095774.1742498237@sss.pgh.pa.us> <e11dd37a-3409-175e-040d-c773838b7934@gmx.net> <556498.1742744802@sss.pgh.pa.us> <3764bde7-ca09-a8a3-489c-0166f772245d@gmx.net> <1cbb9bd6-60cd-92cb-c3c2-4cf4fd8a7b64@gmx.net>
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==


Sent proper patch to pgsql-hackers mailing list, at:

https://www.postgresql.org/message-id/flat/2edb7a57-b225-3b23-a680-62ba90658fec%40gmx.net

References:
- parallel pg_restore blocks on heavy random read I/O on all children processes
  - From: Dimitrios Apostolou
- Re: parallel pg_restore blocks on heavy random read I/O on all children processes
  - From: Tom Lane
- Re: parallel pg_restore blocks on heavy random read I/O on all children processes
  - From: Dimitrios Apostolou
- Re: parallel pg_restore blocks on heavy random read I/O on all children processes
  - From: Tom Lane
- Re: parallel pg_restore blocks on heavy random read I/O on all children processes
  - From: Dimitrios Apostolou
- Re: parallel pg_restore blocks on heavy random read I/O on all children processes
  - From: Dimitrios Apostolou

Prev by Date: Re: parallel pg_restore blocks on heavy random read I/O on all children processes
Next by Date: Very slow query performance when using CTE
Previous by thread: Re: parallel pg_restore blocks on heavy random read I/O on all children processes
Next by thread: Re: parallel pg_restore blocks on heavy random read I/O on all children processes
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]