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 1wTB5E-000MjD-1O for pgsql-hackers@arkaria.postgresql.org; Sat, 30 May 2026 04:14:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wTB5B-005IAh-01 for pgsql-hackers@arkaria.postgresql.org; Sat, 30 May 2026 04:13:57 +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 1wTB5A-005IAZ-2J for pgsql-hackers@lists.postgresql.org; Sat, 30 May 2026 04:13:57 +0000 Received: from fout-a6-smtp.messagingengine.com ([103.168.172.149]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wTB58-00000000Dji-3lWj for pgsql-hackers@lists.postgresql.org; Sat, 30 May 2026 04:13:56 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.phl.internal (Postfix) with ESMTP id 28017EC0104; Sat, 30 May 2026 00:13:54 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Sat, 30 May 2026 00:13:54 -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=1780114434; x=1780200834; bh=hX6F7bvUiQ XtX2VPw7NsKGKIlaMNmHmxb4B79BmYL5M=; b=JlG1/1+vE/GvoK/pB36uSh7LkV 7XoL4Lam36GKSb0Domd3FW0ZPJcrU4o01gZR49rjT65z3iAOJ6uA8O81CK9xsnMS eTjuBSGZrOCJufLJS4Afwj0e2/9ZP6HyX9JTuOxXmFg6DjEv2v3PqVUznHgbmIUg KITuhL/agLhfFwd1tTojIa8NI9Nu405aVUgTR8Ig8K1JOuczAbWaTK2cSbmDsUeP WeDzTVXbqlNxi+sElpZF3fhpWEFsN3BnzkFNfWM8cMAjFgg7elqymNaZ3ZTLD09L 2Qh8G7uCZ8LaHdSaNaCjVBXcB9yAzgGyBVTs3kuDtqKynCvusvPzuicA94AQ== 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= 1780114434; x=1780200834; bh=hX6F7bvUiQXtX2VPw7NsKGKIlaMNmHmxb4B 79BmYL5M=; b=jKZAOsEHbaEGPE4aVF97z9ERfbkhEA0Xnq2BrtWWOy1R3XlLRXl 9du4C0b7lQIQdorahjXrSGtaIqytmRMKgY3kt3nnwniXVoqIqgo3faX+cVtWOxG2 IQZkNVV2QnZWmnQBzs6j+ax230iCkSE6J4KavqWc9cR0O3NrTIXITG6bN2jB8/mn da3kRBFyqeIkT/EesdGzJ/fGElk1xLosWmdu9MLizjeanmClmCCvH9cxTQGTEnjS OvzB05bwKMgVU0+EqpYrCoAChvwfvxzEAxP5War0i7U7JbrYhCJQk8UiUHjwrlJO P66hMoiUh4YSPASvwU/iyPfYLYl4xywMw6g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTECpB4SKaK2J/ZMXKxp9Qhju1OZaIFVHUUX92rnrDdGvN5qT6cAwgjfZiLOlXbERj C8IF2R2HqMi5YPti3tifVEAEUdL/CdGtGljFFd3J1RVbU6Y2yYeV262JymB8FYOtA4I6cF y+WegG74JslrbOXVMGOGav+c+603gPTxWNOrxKyHNmNGgwZzfLu6D8IBNZXYoXqxTQOQUc vX6leOzstkKH6BVEuMuvTMLTgqIe6C4MI+aiYcoqqSAyuB/IhQJZtPSMS/2IoG0D/psJXq QkSsR6er25QQycqfoaz8aIAJDCEUmpeWiYEVzMHJMz6yMUbsWbnjrocKjI/DugbvwBq4P0 daecawqUladb7EcOJYrKY9wNy9wy5qB7NdpdicPCvcDITvwZzBYIRQNYPiVE15S/bOo6rn ITEYtnjKrhTWQpbGSLjiEvc4+LJErN7wzMxCRGdIjqoPaqX4xd7Juggnt3krB0lzobIKdK kL2HqJagDKQxSAolrbsLcH3ppM/V4tMK8Uk8xy0ucHsY+QSPfPH/AkBhZr8o0d5LU4V6A8 5+HMAGQEIPj6NI0bGoRumebZsx3YrJq0oYqMrZ/yBCZ2aY7f2afs43Gv/BIN8OE4LweTCh X7UPRxpvXi5cxky9a/AQjn4M5ek0zX1nSL0m0zUGrd4yx5EA2UgXdyRBCLCw X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 30 May 2026 00:13:52 -0400 (EDT) Date: Sat, 30 May 2026 13:13:47 +0900 From: Michael Paquier To: Robert Haas Cc: Heikki Linnakangas , Postgres hackers , Andrey Borodin Subject: Re: injection_points: Switch wait/wakeup to use atomics rather than latches Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="PkR1Q9wa54lcaATQ" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --PkR1Q9wa54lcaATQ Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, May 29, 2026 at 12:00:46PM -0400, Robert Haas wrote: > On Fri, May 29, 2026 at 9:31=E2=80=AFAM Heikki Linnakangas wrote: >> They only work after you have a PGPROC slot. If you want to inject code >> to authentication, or into postmaster, you cannot use them. >=20 > OK, got it now. It seems like Heikki's comment was better worded than mine. Also mentioned upthread, but the lack of PGPROC also means a lack of monitoring as wait events cannot be tracked. Currently, we rely on that in the TAP tests. For cases where the procs are not available, I don't have a better idea than generating a LOG entry after the wait counts have been generated (with a PID) and couple that with a poll of the server logs to let a script understand that a process is in waiting mode. As a whole, I don't think that we should try to be fancy with the implementation, which is why I have used primitives that should work in any context, and I'm not convinced that this is worth its own facility if that just means more responsiveness (in most cases the wait should not take more than a couple ms to notice a wakeup). I'm open to more fancy ideas, of course. -- Michael --PkR1Q9wa54lcaATQ Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmoaY/sACgkQnvQgOdby QH08sA//eeZF7jKyn+/SCfnTCM7KDSfUlkKkIDoZ9baBDdRj7bVJVt+jnGOTgKz0 2ZzRR44189Vn4vGVQId8HVAUbEHgljdRmPcb8bi3G7H9UyFoLT1oXwmztIwB5fnK iyLw/h5Lpe8tEo5QGFjzJv46Adp9DrWrsGYJEymxzb9JQQ8SW5Ho8GogAaf+iPCu +g2rm3NDitVZEE5NCkWAWD52cH3uN+Apq6EfeG7TRiOVUmYw6AGdBLDwmnxQIu2S Zs2kRihQzlzjqpGtF/AXnjSXFQNv2+spk9FCf1K1PEDz+r1tB4Q7L5ou5Fc3R97X WTMSutqKeQ5Kb0zOJaB+FGDLBv8s63vo7Lx0H1pQ5TwAb2r21N9NPTS7duJKrMc6 AsLzgBT5RNJKc8OeWGAIUJPdqoWEdr760+ZOwOgapxugSkScq7HRUe2AGckq+MZB rNqN3DROpmPDey7LR9+pTqX0AFGO+nrGixDgdk/BNPqE+MnZ1X+02ggoTtneYLcW Tfn1vaIEs8PWpjfE53KAWCL5aoa40pZ3j6qff7RuOi8CZHNyWodnjCLWJX8qAP6Z HGEuxRFfAPz393YPcfx8iXyrfmY8HKB/LHHL3fYCTkJ36ZF5Y744MHkJJtH0IKh5 kH4CC5jaJXxdstk4GPRGmSYyc2ME+iTuGf/XvW2WGNj4CARr5/k= =W3qd -----END PGP SIGNATURE----- --PkR1Q9wa54lcaATQ--