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 1vgSli-00DO9l-1J for pgsql-committers@arkaria.postgresql.org; Thu, 15 Jan 2026 19:12:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vgSlh-000Y7L-1O for pgsql-committers@arkaria.postgresql.org; Thu, 15 Jan 2026 19:12:29 +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 1vgSlh-000Y6h-0c for pgsql-committers@lists.postgresql.org; Thu, 15 Jan 2026 19:12:29 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vgSle-000cIp-0I for pgsql-committers@lists.postgresql.org; Thu, 15 Jan 2026 19:12:28 +0000 Received: from gemulon.postgresql.org ([72.32.157.198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vgSld-001nvz-1a for pgsql-committers@lists.postgresql.org; Thu, 15 Jan 2026 19:12:26 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vgSld-000fFk-2J for pgsql-committers@lists.postgresql.org; Thu, 15 Jan 2026 19:12:26 +0000 Content-Type: multipart/mixed; boundary="===============5440743636722287054==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Optimize LISTEN/NOTIFY via shared channel map and direct advance X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 15 Jan 2026 19:12:26 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5440743636722287054== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 T3B0aW1pemUgTElTVEVOL05PVElGWSB2aWEgc2hhcmVkIGNoYW5uZWwgbWFwIGFuZCBkaXJlY3Qg YWR2YW5jZW1lbnQuCgpUaGlzIHBhdGNoIHJld29ya3MgTElTVEVOL05PVElGWSB0byBhdm9pZCB3 YWtpbmcgYmFja2VuZHMgdGhhdCBoYXZlCm5vIG5lZWQgdG8gcHJvY2VzcyB0aGUgbm90aWZpY2F0 aW9uIG1lc3NhZ2VzIHdlIGp1c3Qgc2VudC4KClRoZSBwcmltYXJ5IGNoYW5nZSBpcyB0byBjcmVh dGUgYSBzaGFyZWQgaGFzaCB0YWJsZSB0aGF0IHRyYWNrcwp3aGljaCBwcm9jZXNzZXMgYXJlIGxp c3RlbmluZyB0byB3aGljaCBjaGFubmVscyAod2hlcmUgYSAiY2hhbm5lbCIgaXMKZGVmaW5lZCBi eSBhIGRhdGFiYXNlIE9JRCBhbmQgY2hhbm5lbCBuYW1lKS4gIFRoaXMgYWxsb3dzIGEgbm90aWZ5 aW5nCnByb2Nlc3MgdG8gYWNjdXJhdGVseSBkZXRlcm1pbmUgd2hpY2ggbGlzdGVuZXJzIGFyZSBp bnRlcmVzdGVkLApyZXBsYWNpbmcgdGhlIHByZXZpb3VzIHdlYWsgYXBwcm94aW1hdGlvbiB0aGF0 IGxpc3RlbmVycyBpbiBvdGhlcgpkYXRhYmFzZXMgY291bGRuJ3QgYmUgaW50ZXJlc3RlZC4KClNl Y29uZGx5LCBpZiBhIGxpc3RlbmVyIGlzIGtub3duIG5vdCB0byBiZSBpbnRlcmVzdGVkIGFuZCBp cwpjdXJyZW50bHkgc3RvcHBlZCBhdCB0aGUgb2xkIHF1ZXVlIGhlYWQsIHdlIGF2b2lkIHdha2lu ZyBpdCBhdCBhbGwKYW5kIGp1c3QgZGlyZWN0bHkgYWR2YW5jZSBpdHMgcXVldWUgcG9pbnRlciBw YXN0IHRoZSBub3RpZmljYXRpb25zCndlIGluc2VydGVkLgoKVGhlc2UgY2hhbmdlcyBwZXJtaXQg dmVyeSBzaWduaWZpY2FudCBpbXByb3ZlbWVudHMgKGludGVnZXIgbXVsdGlwbGVzKQppbiBOT1RJ RlkgdGhyb3VnaHB1dCwgYXMgd2VsbCBhcyBhIG5vdGljZWFibGUgcmVkdWN0aW9uIGluIGxhdGVu Y3ksCndoZW4gdGhlcmUgYXJlIG1hbnkgbGlzdGVuZXJzIGJ1dCBvbmx5IGEgZmV3IGFyZSBpbnRl cmVzdGVkIGluIGFueQpzcGVjaWZpYyBtZXNzYWdlLiAgVGhlcmUgaXMgbm8gaW1wcm92ZW1lbnQg Zm9yIHRoZSBzaW1wbGVzdCBjYXNlIHdoZXJlCmV2ZXJ5IGxpc3RlbmVyIHJlYWRzIGV2ZXJ5IG1l c3NhZ2UsIGJ1dCBhbnkgbG9zcyBzZWVtcyBiZWxvdyB0aGUgbm9pc2UKbGV2ZWwuCgpBdXRob3I6 IEpvZWwgSmFjb2Jzb24gPGpvZWxAY29tcGlsZXIub3JnPgpSZXZpZXdlZC1ieTogVG9tIExhbmUg PHRnbEBzc3MucGdoLnBhLnVzPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzY4OTlj MDQ0LTRhODItNDliZS04MTE3LWU2ZjY2OTc2NWY3ZUBhcHAuZmFzdG1haWwuY29tCgpCcmFuY2gK LS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3Jn L3BnL2NvbW1pdGRpZmYvMjgyYjFjZGU5ZGVkZjQ1NmVjZjAyZWIyN2NhZjA4NjAyM2E3YmI3MQoK TW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvYXN5bmMu YyAgICAgICAgICAgICAgICAgICAgfCAxMTQxICsrKysrKysrKysrKysrKysrKystLS0tCnNyYy9i YWNrZW5kL3V0aWxzL2FjdGl2aXR5L3dhaXRfZXZlbnRfbmFtZXMudHh0IHwgICAgMSArCnNyYy9p bmNsdWRlL3N0b3JhZ2UvbHdsb2NrbGlzdC5oICAgICAgICAgICAgICAgIHwgICAgMSArCnNyYy90 ZXN0L2lzb2xhdGlvbi9leHBlY3RlZC9hc3luYy1ub3RpZnkub3V0ICAgIHwgIDEyNCArKy0Kc3Jj L3Rlc3QvaXNvbGF0aW9uL3NwZWNzL2FzeW5jLW5vdGlmeS5zcGVjICAgICAgfCAgIDcyICsrCnNy Yy90b29scy9wZ2luZGVudC90eXBlZGVmcy5saXN0ICAgICAgICAgICAgICAgIHwgICAgNiArCjYg ZmlsZXMgY2hhbmdlZCwgMTE2MSBpbnNlcnRpb25zKCspLCAxODQgZGVsZXRpb25zKC0pCgo= --===============5440743636722287054==--