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 1rtcad-00GESI-QV for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Apr 2024 00:10:24 +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 1rtcab-00EMVT-Nq for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Apr 2024 00:10:21 +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 1rtcab-00EMVJ-EF for pgsql-hackers@lists.postgresql.org; Mon, 08 Apr 2024 00:10:21 +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 1rtcaX-001jTP-CB for pgsql-hackers@postgresql.org; Mon, 08 Apr 2024 00:10:20 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id A3C8E5C0058; Sun, 7 Apr 2024 20:10:15 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Sun, 07 Apr 2024 20:10:15 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc: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=fm2; t=1712535015; x=1712621415; bh=UJngGZeYPb kDXNQ6iMP5Z9uyCCTDm8sz80bsrwh2xpo=; b=o0FUznWPlprJRRnhbnoQBilipk xQBka7YAy+sksCIqDFHqyZ/RtdAk0fPPY9zWT2jmUBSiS3+JH1GRAI04Rqx9OrIc qDhgqc/Tpr4KToDE1AkqHgUbNzu1GSWFchcPujy5p+573Sz8hyLvqzJPTFVhk8IP aOAStCXdpl3NtoMu2QA2I7pI5/v5tViot55Tyja57SrQUs6JoohqogFdqguI3eer kwJgEkHGWIOnoQsUH6eHuWNnb4XVqRLexeD1nD0vCip7LuHPGtpEzfjMs6A7oqPq 29exfrNWJSxonz7s6BPT1tAQNIoxN+MhSUYZiRSztmgH2uBp7nvWrNi+hpfw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc: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-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1712535015; x=1712621415; bh=UJngGZeYPbkDXNQ6iMP5Z9uyCCTD m8sz80bsrwh2xpo=; b=bqL3bn6hYkYarN0l1mosACAK59hbbwTYY0HZsRqboo0e gFVM8WKN7PDjPXvTLAU21n/RyBIvCiH5QLV/bsrOQNQGqq3uRKDLnX7uW1kle0LF s7Y1eGnv+Ouy1tv5R9foy7e/tM7GQ7snAvHUgBeW0HTdX3zeE4UjHDeWHqHgSkUP uzWoP4I5ksJ/oDb9KNzqDk4zZh/OtE9Rsx9XG8MxWxOIFib+0vJPW94UcZ/w4LVh NBp0SKPg3o84+635wGQ0JzPFtG19puHbD43yFTb7xQ5wCdWX+UY4kgZnPWbnKrXk Iziw82PJmSpZ9qwsNHwcBOYnAfAFAJvJFxlg/kdVZQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrudeghedgfeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughr vghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecuggftrf grthhtvghrnhepvdfffeevhfetveffgeeiteefhfdtvdffjeevhfeuteegleduheetvedu ieettddunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomh eprghnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 7 Apr 2024 20:10:14 -0400 (EDT) Date: Sun, 7 Apr 2024 17:10:13 -0700 From: Andres Freund To: Thomas Munro Cc: Maxim Orlov , vignesh C , Palak Chaturvedi , Jim Nasby , pgsql-hackers@postgresql.org, Nitin Jadhav Subject: Re: Extension Enhancement: Buffer Invalidation in pg_buffercache Message-ID: <20240408001013.x7x5q45hhu4xecjn@awork3.anarazel.de> References: <8b8c709a-c7cc-4965-8296-64f549c27501@abcsql.com> <3510716d-d3f3-40c8-9f7f-d644171acfb6@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2024-04-07 11:07:58 +1200, Thomas Munro wrote: > I thought of a better name for the bufmgr.c function though: > InvalidateUnpinnedBuffer(). That name seemed better to me after I > festooned it with warnings about why exactly it's inherently racy and > only for testing use. I still dislike that, fwiw, due to the naming similarity to InvalidateBuffer(), which throws away dirty buffer contents too. Which obviously isn't acceptable from "userspace". I'd just name it pg_buffercache_evict() - given that the commit message's first paragraph uses "it is useful to be able to evict arbitrary blocks" that seems to describe things at least as well as "invalidate"? Greetings, Andres Freund