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 1wPfOo-000w98-0B for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2026 11:47:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wPfOm-007QB1-0F for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2026 11:47:41 +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 1wPfOl-007QAo-2W for pgsql-hackers@lists.postgresql.org; Wed, 20 May 2026 11:47:40 +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 1wPfOk-00000000TtI-0tCs for pgsql-hackers@postgresql.org; Wed, 20 May 2026 11:47:39 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id 677A9EC013A; Wed, 20 May 2026 07:47:38 -0400 (EDT) Received: from phl-imap-08 ([10.202.2.84]) by phl-compute-05.internal (MEProxy); Wed, 20 May 2026 07:47:38 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=compiler.org; h= cc:cc:content-transfer-encoding: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=1779277658; x=1779364058; bh=vNqi73zCcwsjlWMhzxH/g2KznhmA9dj9rwjAJXByuu8=; b= TGHcMxgCjx6miWNpegAipGYplZhJ8gM1Dh3iBaCDKNBDdIJx8gzJ1sAUnhDScKAf KpIoy0RCIqu5k266fjUUM+oeNBicxmnf8HdduYFctDs8dlo/a/6S7zu9mY3RfmDE JO5dwFinas+032ZozIPvcb0er4OTDnnMxQseMMlkSYfHW/qwy2Yz7uEo9jbRz8oV EViOG13BwsBCDRzZPuYcaWvVRgzipB2mL2xzAqGaiyp34Dc0YpPDdMhgSRpYKtGL Q8PBPGEXWxXteJpF2c1Ag0hnUFXJaIMwy5kBcMtCo+14blDRVUYDDRenAT8AXlhR YREmqH7NHwNd7QyvznZpzw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :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=1779277658; x= 1779364058; bh=vNqi73zCcwsjlWMhzxH/g2KznhmA9dj9rwjAJXByuu8=; b=n 9WkRDHMjz8DiB2l3+GRCSMOncAxKHiz+9nB/dlQJVehyFTU/fVuhWA/C0yI+6sZm r5bBt+GTM+NIGszmzZcxuJbs0SPeo6917Pd2ZUh1C38Zd9XWmLe4Z6MtajHxTdes 3ZZxHiWLi+1z5p+x73LqBp4VKBhiKVME2KXYs9efOGufvB3TYJRiI14fHBIwMdwn 6/hlp2+GWlZ57FbOXzDg8iThZ7euSfkm3Vba6/5FznacNwTKrmZWyKXPx0FKsOZJ v1qw/qgUz9wbfFDXr7jgdp171YXb8VbwvuGqlVIk693R9Ev2ulC9jqulN2Q9ss4y N4hUDjaYyCLASGVuAZe1w== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefhedrtddtgddugeegheehucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucenucfjughrpefoggffhffvvefkjghfufgtgfesthejre dtredttdenucfhrhhomhepfdflohgvlhculfgrtghosghsohhnfdcuoehjohgvlhestgho mhhpihhlvghrrdhorhhgqeenucggtffrrghtthgvrhhnpeefheelffegvdelfeevteejtd ekteefleeihfdtudelkeeijedtvefgueevieekieenucevlhhushhtvghrufhiiigvpedt necurfgrrhgrmhepmhgrihhlfhhrohhmpehjohgvlhestghomhhpihhlvghrrdhorhhgpd hnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegvgigt lhhushhiohhnsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvg hrshesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ic6394509:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id 23C682CE0072; Wed, 20 May 2026 07:47:38 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: AE1r89ybsZ1g Date: Wed, 20 May 2026 04:47:09 -0700 From: "Joel Jacobson" To: "Alexander Lakhin" Cc: pgsql-hackers Message-Id: <025766ac-78da-4b0c-a50f-d2d13d2fdad1@app.fastmail.com> In-Reply-To: <037ce9cd-28ad-4c19-9be1-d8c1f577a322@gmail.com> References: <6899c044-4a82-49be-8117-e6f669765f7e@app.fastmail.com> <2531672.1759868124@sss.pgh.pa.us> <474efa78-337c-41cd-a73a-f845a0115109@app.fastmail.com> <2749343.1759949176@sss.pgh.pa.us> <8bfca2be-1ec0-4e15-aafb-0b7b661fe936@app.fastmail.com> <9eba307f-f2fb-48f0-9507-2e197f39ef9e@app.fastmail.com> <8c71183a-0d28-4bcf-a806-78446ff95404@app.fastmail.com> <1009807.1760476747@sss.pgh.pa.us> <1F7227F5-C33D-4E2C-8511-33F1468590D0@gmail.com> <0a5a20d3-4621-46b3-b2ab-903f63a20dea@app.fastmail.com> <6F913129-ABEF-4004-AAF3!-F!!22!F!C!3!4!29AE8@gmail.com> <1547585.1760645808@sss.pgh.pa.us> <14865EB6-0BF4-462B-9<803584.1768503335@sss.pgh.pa.us> <037ce9cd-28ad-4c19-9be1-d8c1f577a322@gmail.com> Subject: Re: Optimize LISTEN/NOTIFY Content-Type: text/plain Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Apr 18, 2026, at 21:00, Alexander Lakhin wrote: > While browsing through new inconsistencies and typos, I came across one > which I'm not sure what to do with. Could you help, please? > > async-notify.spec contains: > # Check ChannelHashAddListener array growth. > permutation listenc llisten l2listen l3listen lslisten > > But as far as I can see, ChannelHashAddListener() was eliminated in > 0002-optimize_listen_notify-v13.patch upthread [1]: > >> > Or thinking a little bigger: why are we maintaining the set of >> > channels-listened-to both as a list and a hash? Could we remove >> > the list form? >> Yes, it was indeed possible to remove the list form. >> > > So, maybe the comment or perhaps even the test case should be changed/ > removed? Yes, that test is a leftover from a previous patch version. I'll post a patch to remove it in a separate thread. Thanks for spotting. /Joel