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 1rf0Hd-00Erog-RI for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Feb 2024 16:26:22 +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 1rf0Hc-0046bZ-9L for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Feb 2024 16:26:20 +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 1rf0Hb-0046bQ-LA for pgsql-hackers@lists.postgresql.org; Tue, 27 Feb 2024 16:26:20 +0000 Received: from fout4-smtp.messagingengine.com ([103.168.172.147]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rf0HU-001XV6-2r for pgsql-hackers@lists.postgresql.org; Tue, 27 Feb 2024 16:26:18 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailfout.nyi.internal (Postfix) with ESMTP id ADFC2138009A; Tue, 27 Feb 2024 11:26:11 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Tue, 27 Feb 2024 11:26:11 -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=1709051171; x= 1709137571; bh=jtGjD86eE0OLFBMs/+Q3d/o9h/6j5bodDpwGnALymEE=; b=Z MrlTyHU0iCcJ4cb8q1lC+v0zB4La04jX9ffGD0/UBc74aNOz/lRuG0tT7Eoonf6i D3VCqOFACMdyxkrFxdxwBe8hBbqnrIbHYxud8nyPkvvhFkK3N7N/p/UOWfImLddQ YGft6NqdOyGazfaHF5a+1EwzNCpr63Obo+8AeocxPdYNJ060X6n2P4CjvfMtc+go 0FsHY1i2BoOHDj0EuzL7u9evaUU9ANfbS+opf7NEn8Qi/pQxxJrUtxOhYzy5Au/8 4563TYw2b7yGlMpUgstzOTpQyulQPt43+pC+1gsoDs0d2dEiTU8quzdcCwUkrFBn HcR2pbDJoj9N7rH2IbTVQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrgeehgdeigecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedvkedtffduffdtffffheffhfejjefhgfeiueeukeejkeff gfdufffhudffffeuveenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 27 Feb 2024 11:26:11 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1709051167; bh=UsIlRWg4JbROMjrROZxoSItT/XStedJgjMZ+ZAckjUQ=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=ILWj/KS8BmIAK3Ql5XCdTD+j3GroC8XAOao8+e8umAGgKEXp7aUtDQIvCtVnfNnjx L3GPAnAdKNMq5z1ZvOH+j4Vkz2KS8Xwp4FIIlNa8E2apUu9EIJd0DPF4ure3ujHNA1 k2AVt1D670tycGrqS0tYUoJM6KAAM+DGJVpjb+HIBuBO7iatW06gBuJjOLoiD8FQzy he9hTtYe12Z+9k/yu08eCxRCMxILZ12kXcuE6G+3aXi4kFXVXUa48f4bRWL5UPrbYT 9a9a402X/D1nsjed3TnEKMpx05dFijZJjnflgkzNYAWJqG0yZKLKdxtltet3VZy94B yPvQOH/OuEe5g== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id CBFAD12B0; Tue, 27 Feb 2024 17:26:07 +0100 (CET) Date: Tue, 27 Feb 2024 17:26:07 +0100 From: Alvaro Herrera To: "Andrey M. Borodin" Cc: Dilip Kumar , tender wang , PostgreSQL Hackers , Tomas Vondra Subject: Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Message-ID: <202402271626.ilamiem7n3hl@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <8E9F1FB8-3F89-4114-9732-42057C02112B@yandex-team.ru> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-Feb-27, Andrey M. Borodin wrote: > Sorry for the late reply, I have one nit. Are you sure that > multixact_members and multixact_offsets are plural, while transaction > and commit_timestamp are singular? > Maybe multixact_members and multixact_offset? Because there are many > members and one offset for a givent multixact? Users certainly do not > care, thought... I made myself the same question actually, and thought about putting them both in the singular. I only backed off because I noticed that the directories themselves are in plural (an old mistake of mine, evidently). Maybe we should follow that instinct and use the singular for these. If we do that, we can rename the directories to also appear in singular when/if the patch to add standard page headers to the SLRUs lands -- which is going to need code to rewrite the files during pg_upgrade anyway, so the rename is not going to be a big deal. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Crear es tan difícil como ser libre" (Elsa Triolet)