On Fri, Jul 20, 2018 at 05:58:13PM +0900, Yugo Nagata wrote: > He reported this problem to pgsql-general list as below. Also, he created a > patch > to add a build-time option for adding 0.5 or 3.0 seconds delay after each sub > process starts. The attached is the same one. Our client confirmed that > this > patch resolves the dead-lock problem. Is it acceptable to add this option to > PostgreSQL? Any comment would be appreciated.
If the OS startup gets slower, then an arbitrary delay is not going to solve things and you would finish by facing the same problem. It seems to me that we need to understand what are the low-level locks which get stuck, if it is possible to make their acquirement conditional, and then loop conditionally with multiple retries. -- Michael
signature.asc
Description: PGP signature