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 1r3Ysp-004WTu-O3 for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Nov 2023 09:42:00 +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 1r3Yso-005spL-35 for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Nov 2023 09:41:58 +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.94.2) (envelope-from ) id 1r3Ysm-005spC-FE for pgsql-hackers@lists.postgresql.org; Thu, 16 Nov 2023 09:41:57 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r3Ysj-005q5v-Oi for pgsql-hackers@lists.postgresql.org; Thu, 16 Nov 2023 09:41:55 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 37B985C0062; Thu, 16 Nov 2023 04:41:52 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Thu, 16 Nov 2023 04:41:52 -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:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1700127712; x= 1700214112; bh=nyEQGUPBMT8B6pmzEceHrV6bEK5b2q9OMBflNQfDaW0=; b=E +IJz+6YoUIW2uO6BVb8FnWikX9UhKp/vgFVtT0f34XYjPyyi1mC/csXC7K1RGRnG m9ZjwHZvROjPtdNl4gjB2CVU41krqF8IorCj+8p4Up+l+ovc5fqKHDHiSfMrfWf/ kvj5qeqyPuK4+csZ2FzxjwfM6BmypGgcsyeoTvpBYM0Trhlsc2dMOOVdOTy3IKIE bgeXAz0bZZOUMqmYHMkG5Y4hswVtr9W+SHCQTZu4vb+uhzRNXzly8QkC1oUO8vVu UssuwizfQAaDFAgNMziPOt4oFifvg9pr//QLpzOIpKZ/4JpyZwRMjjw1yfjsPrcv tEVufk7iKbf3RnPQTeRrw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrudefkedgtdehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepledvkedvueelteefffevjefgfeeuleehjedtieevjeel ffegfeelgedvteekvdetnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomh dpphhoshhtghhrrdgvshenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 16 Nov 2023 04:41:51 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1700127708; bh=K5y5Q10KpUhyJbThp9KVZPY0+KBPUeMPo51vW7HAAyE=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=qE3LeCWTykMPKu/dkbNEXq3irzJ6P3UlKsc+k65txKAhNOiD6vR8DUFDUbm0VyZfh 18asMx+lEIrwb9NnFsFdAnYAv9+oUrBxRtBjNmwyv9ctrAnxlPTgXlzbYu6c5ZinEw hQzFRH9gSHfsNTkVThMN4/+eSs8ZTn7rDbRwGZd1CdbS0kyffqkuxp3iHASDnnHO4N UboM4FWz/ZflM3OVFwciJfTEvWAOjv+EKhHXONyLneDMVGVDfkbsYiCOGw34EJpPLd +lHB+uRQrwYqnz9263jFCYUCippQcP2BLQzGib1PHlCSE9V2wgiibUbMZUV+8y+/Lf uBCQ8lwKy71zg== Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id F167FDE; Thu, 16 Nov 2023 10:41:48 +0100 (CET) Date: Thu, 16 Nov 2023 10:41:48 +0100 From: Alvaro Herrera To: Dilip Kumar Cc: "Andrey M. Borodin" , PostgreSQL Hackers Subject: Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Message-ID: <202311160941.olx5z3a7pkww@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I just noticed that 0003 does some changes to TransactionGroupUpdateXidStatus() that haven't been adequately explained AFAICS. How do you know that these changes are safe? 0001 contains one typo in the docs, "cotents". I'm not a fan of the fact that some CLOG sizing macros moved to clog.h, leaving others in clog.c. Maybe add commentary cross-linking both. Alternatively, perhaps allowing xact_buffers to grow beyond 65536 up to the slru.h-defined limit of 131072 is not that bad, even if it's more than could possibly be needed for xact_buffers; nobody is going to use 64k buffers, since useful values are below a couple thousand anyhow. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ Tom: There seems to be something broken here. Teodor: I'm in sackcloth and ashes... Fixed. http://postgr.es/m/482D1632.8010507@sigaev.ru