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.94.2) (envelope-from ) id 1rhCGO-00A8rx-37 for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2024 17:38:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rhCFN-009iwg-1R for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2024 17:37:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhCFM-009iwY-Fi for pgsql-hackers@lists.postgresql.org; Mon, 04 Mar 2024 17:37:05 +0000 Received: from fout7-smtp.messagingengine.com ([103.168.172.150]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhCFI-002kvV-Jt for pgsql-hackers@lists.postgresql.org; Mon, 04 Mar 2024 17:37:04 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailfout.nyi.internal (Postfix) with ESMTP id C1EA01380096; Mon, 4 Mar 2024 12:36:58 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Mon, 04 Mar 2024 12:36:58 -0500 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 :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1709573818; x= 1709660218; bh=iYlKBPp3oX6V3ZNm3kns0ifSIvYr8n9zTAah2//mmv4=; b=L g8Qqkauz8raiyX/octNh+Mdl+zKyZ9h35+j3y/d/33xBh9U0/s0cs6c9SwA+P+AX m8Y2oGfZQbx8V0ZcgOGJfe5qFrG9PQoMwksEY6umDX0NNivr3Y/YxFav4lJrTyew 9lslRgwrFT3MsrP6fNtOOiEUjj1PSGwA313WDtYT8kdPJc1sqcZJNusL6fVS/1V6 Wy9LYiw0140tocW09T6CEoKgi0vUIwzoNuHX0avEJPwVH8Br59J54m+d/qNddado 9RIxVgXDeVoF4Z7dOarowN7l1pxe5vjBYZSI2dzQipWUqpY+cRuArLphMG2tRxXW 1ZremYk8z6ME423I5zvrA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrheejgddutdduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpeffhffvvefukfggtggugfgjsehmke erredttdejnecuhfhrohhmpeetlhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhr vgesrghlvhhhrdhnohdqihhprdhorhhgqeenucggtffrrghtthgvrhhnpeduleekkefgtd dttedtkefguddvieffleetgeejiefhteehkeevfeettdduvdfhueenucffohhmrghinhep vghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrg hrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhr gh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 4 Mar 2024 12:36:58 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1709573816; bh=cpngo/Siz1PYjrmLztbJzczi7F/4732QhNdvucMYyT4=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=Jpfcu/B6cdipH2Je8uXxW/9onu1I/lDIPfnkYAJj/0VXR1WCKeeO64zJRzST5PWpx bRvWh12ZvCRJ7m6rI5wILSvVa0XBufa+Wzkgv7t9Y6NtUH2ybZpJd/uCcL484nZi+i xOk/jy444ssYUDn9vPVYzPOmrFWoZZuJZAhdGO/mTCDvnP4krS6cH0/pc0zngr5QF9 grR6iyHGObnlGWcz5H3LVoXovErLFtnAt6HXN7DdIivgWLDUpUoS6n8qYUrs7X+S7G g4XYXukp7Xl8ZbQv5tLL3M/TSE8DnVtBmc1g+CVy83lWfpc8rava/JEbEKS6uM8Ci1 tVqJSp/cK8GXA== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 0054DCD5; Mon, 4 Mar 2024 18:36:55 +0100 (CET) Date: Mon, 4 Mar 2024 18:36:55 +0100 From: Alvaro Herrera To: Tom Lane , Dilip Kumar Cc: pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: Improve performance of subsystems on top of SLRU Message-ID: <202403041736.k5mrz5ntswt5@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="r4q4lfzvecohuykp" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202403041517.3a35jw53os65@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --r4q4lfzvecohuykp Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit FWIW there's a stupid bug in 0002, which is fixed here. I'm writing a simple test for it. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "Now I have my system running, not a byte was off the shelf; It rarely breaks and when it does I fix the code myself. It's stable, clean and elegant, and lightning fast as well, And it doesn't cost a nickel, so Bill Gates can go to hell." --r4q4lfzvecohuykp Content-Type: text/x-diff; charset=utf-8 Content-Disposition: attachment; filename="v3-0001-Rework-redundant-loop-in-subtrans.c.patch"