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.96) (envelope-from ) id 1wSqkW-0009GV-01 for pgsql-hackers@arkaria.postgresql.org; Fri, 29 May 2026 06:31:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wSqkT-001k3c-2f for pgsql-hackers@arkaria.postgresql.org; Fri, 29 May 2026 06:31:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wSqkO-001k3T-0b for pgsql-hackers@lists.postgresql.org; Fri, 29 May 2026 06:31:13 +0000 Received: from fhigh-a8-smtp.messagingengine.com ([103.168.172.159]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wSqkL-0000000053w-1Cah for pgsql-hackers@lists.postgresql.org; Fri, 29 May 2026 06:31:07 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfhigh.phl.internal (Postfix) with ESMTP id 0F610140008B; Fri, 29 May 2026 02:31:04 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Fri, 29 May 2026 02:31:04 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1780036264; x=1780122664; bh=pgLLvUUk4+ uZcf8aZGyP+glCe74hJuxjHkk/GTXfKdo=; b=dj+O9qjE2AGeAV+w27g/G1luVG C3IYPzqMkskbdcp3D/5ZtZPL5ToB6GHS4o1Q5Np7nsTnIIU6ckWVgRV6+FXo83qq VaJrjC5qiHQZ8ed0/3835rWNKpys2TCLbQcP9Hv62jIDk3kn0VXFDHXU9uzpvEiw 8S0ehNPbK/tfbsDzMEqKFPQyunCkwIfPQjxJrDr7KTCNmPeJNrW/MzvNNGCSB16j KtJjWU3SHz3hs3pW+Bj03v6ImaMpU5TzqWInzn6dmjT47y2h2dSv/zKHzRh4fBbX +22eYRksjpq5ZUI9i8meLVQIw2iCTYT5bpS0vFkDu7reMustHX/549vHg8kg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1780036264; x=1780122664; bh=pgLLvUUk4+uZcf8aZGyP+glCe74hJuxjHkk /GTXfKdo=; b=Q0pNigHaxj13vVx0GvTxkb/m/ZpnX8MripKeUIJGzKq15YoEP/L lPSJjqrzMH5FPWwRB/mZdezBtkfIyPH8Qaw7rX6VVndUajBA4XctodF6Oo9Lf6Hh yaqB7F6iap/N5u+QSxNLRpcLJ11FyvVzneKzoDlUK1DH3VIknPGSATYLCmGGGKm7 +kfqMpmvDees9oDSSwCMm0W5R97/UUAiJFS9b83GgBcoVjwrVCZB8iJntVpqITj4 dfd/bExVbPsvHT87O0cK3M0+9o2COQl1uGFPWII7JiYQb31+G9IH50DJI1Ke4w4v Tr27nudZ6Ny8muHfK4zgXWdgKa8jMXJNhcQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTE9AgU5XWhsZ9DN+h2OhYAU+BqCWmSNGYUVuKSHXW5jnD/v4EaxwsbK1ZC2tYtsXC IYDS2MZeiyPlMxtSeOTOqEC5KmoG8FNgzQk6IanSnj5S3MaMbyaWPChat9G82ktjqyaNA1 JrUU07U1NfdgFBC1hLhFohMAK3/LxZjf1prs4nyvyo/TlesmaZMxYqtkOD398ricCXZZw8 bz8/vlY0yLGNwq05Eee8qcHwB10YOpNLn2r48hj3ijeph3YTE213HrBu2GrA2bFQXRBm6O CuClDREauNQNfT4OJ+U7RVm4zLljHRdSw9d7MmlrfFn7HQSSoB4Pgkmo82d4Y09Fwx7qDU t952FxPeRdITGtro+35Xy8lrLeh8oIQ49Z3jA/ZKUKQk0g6djf4bx9LYBoztbWrO6hUb/C gFdPeAOgHpU2xfCvtWG2Gq3JDfuQl4O0UNbvUbAQ2MrFJ+XuLLeXHIwuriUJ0P+5B/X3wu MCm5U8SFn4oYLfb9WxocTcWxboe+daawRnvlj07A0KovKmdBCITsaUTTjmZi8EQwE74BU5 Nkq8BVfWzaD5RTdCXu3JRZOUljoQNxay1V9BfKdo53MQ15L8JXGpq61Su9DGnQEkhksrzI jgehtmg3d021u5mfSdhTHGGzmoBDp26nM794l2q9WQqgdHX/dQeRvNL8C7Rg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 29 May 2026 02:31:01 -0400 (EDT) Date: Fri, 29 May 2026 15:30:57 +0900 From: Michael Paquier To: JoongHyuk Shin Cc: =?iso-8859-1?Q?=C1lvaro?= Herrera , Fujii Masao , "pgsql-hackers@lists.postgresql.org" , Vitaly Davydov Subject: Re: [PATCH] Prevent repeated deadlock-check signals in standby buffer pin waits Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="S96VJbQ42wAnn187" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --S96VJbQ42wAnn187 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, May 22, 2026 at 05:41:03PM +0900, JoongHyuk Shin wrote: > This patch addresses the opposite, > deadlock_timeout does fire, but LockBufferForCleanup loops back and re-arms > it, so the signal repeats once per second. Right. I don't really see why this should be backpatched. One argument would be more consistency of this area of the code across all the stable branches, but the argument is kind of moot as this does not fix a problem, just improves a bit what we have. -- Michael --S96VJbQ42wAnn187 Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmoZMqEACgkQnvQgOdby QH3iyg/9FG/NqMAgQ4I9uV0H+nluR5tjVsWPPcl4GXv6MSTeCXWUtv7tDjWx2hyW IOG9Ls1DG+gYhOOriIvrLbRDCieTnpIMuaEaT9b4Wy14LIHMc2PnIACuLrGY9gS6 d6Ogt8zcg5NyAl/LbQ7Uc2f5oLX62Ac/ucD7T+xEMvH3O8dFiprXlHx378sxD6PQ ugqEgkVOipwlc7PBMQRLmMY2rl1rRYh340Pg6i/MvF0rIaKmfqZMlhxDIQOSEGxQ YudL2c62gObd+36Zg4hNMKlisPIYjqL6kbeg3sbX3ld96xl/NPL5o/2Nn+6cwZiR 3NNcv40eEIzsNxwdmmjpKk7oukL+5ZJBpT0e+KccIVcpnmkQKIAwSJTTKpTWFxt5 OXDWbTgf4E8v6yp1m8FMyiQhsXB5rxassqcQxmkvVW045PnZNx5mmDkx5zDvp+9u DeAzgc9Y7cACIQTmC+s5oKXsZRcWQsBC0lcF5P4NDoCOHHXjio3C+Ri8nz/jBN0R AYQ71rkw3C/TCS5+0fciKNeAV9CD7Sc4o0fojx0Tt972NdINNiJwTKVu3YJvIZH9 qg5CjPM7boXjHbUrErv1iTM2odzJzFARUqJMIqsEEx0XnU85aDCBhhHnrbCCXjRR 3/6IL9k+HU1/tBJ9wvVBmikN+OoSALx7lxeNbDUAY/OKS+8SjzE= =x7pb -----END PGP SIGNATURE----- --S96VJbQ42wAnn187--