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 1urPCN-005eGb-9Q for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Aug 2025 23:05: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 1urPCM-000Ehf-0O for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Aug 2025 23:04: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 1urPCL-000EhW-EY for pgsql-hackers@lists.postgresql.org; Wed, 27 Aug 2025 23:04:58 +0000 Received: from mail-pg1-x531.google.com ([2607:f8b0:4864:20::531]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1urPCI-0025qE-2o for pgsql-hackers@postgresql.org; Wed, 27 Aug 2025 23:04:56 +0000 Received: by mail-pg1-x531.google.com with SMTP id 41be03b00d2f7-b47052620a6so1095045a12.1 for ; Wed, 27 Aug 2025 16:04:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1756335893; x=1756940693; darn=postgresql.org; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=hwUP1YhjXtDfRjWDKapF3L58xZuRnZUHYKY6RFyssIc=; b=e56HMDzBqqPMXxCGIlDMpSWnIEHxaffjQ0QSsnu1g4HfL6CH71zBsS/t6L70aoIGlv AT6LagONmpziyo7I7wFBxybgL8831nhxOybchqaP1fzzotfqIZOp5BQwuxDYl1L2CE08 g3+VpPWYIXgBfqjO41tRXT/aoo+AN4K+1CPkI= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756335893; x=1756940693; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=hwUP1YhjXtDfRjWDKapF3L58xZuRnZUHYKY6RFyssIc=; b=A0VrHP7amPFR04Tn35w3YtJtMCcuz+iN1WFvzyMrra2LYtpBbWIUfzvE7S1f04Mxv5 voLhcbjw9pY9OIJI2tTL3TcVH54i+ddqZ51dTOn0SLoNpOPsEY4LR+N899Q1AovdU7Hb AhSpVDOsRVmptWrjKRz3oPgSONFXU0kRXwUMTGkvw7cbC3/BFAWr4hj5VnkpKWWT4yGc QlblEt0bUFfdOmKaUIy4F26OQkMK8UA5DYFilOFWhHfAXfhwQfxBHcI0rHDwaR8bfJIM fJ6ldTsDyAMfks3p9dTogFG6UVI556vt7mtA+94OJTxLIjEkpOi3E5yrhox9ydCx4eQ5 wxgg== X-Forwarded-Encrypted: i=1; AJvYcCVE05BJc+7zA3Au1iypcoht9+5x3J+vkmS0PhbtMmA9Xvkq3dgJSoQVUqSEA6RW9xcLFkRkKFjwdNuhfywU@postgresql.org X-Gm-Message-State: AOJu0YxrGwR/rvItZql2zIi0PjEF7Tr5eUEErIDIqcWyT49W7oAqKp6I zOrb4FlTMf2r79qL5c9TsbBGaR2YzRDw81k3zIboAoBvtBCoe0VYL5sbHYbDcBFbsA== X-Gm-Gg: ASbGnctWj8LWY1ah5t0gqV2eITU8FolPyIenqhvCzG7zGuH0g+Cff1cmlTdKQSyl3J2 DtFqNKqO653DmxGO9QDwkOV/Pal0442qdbYxutFlLV0qr+tWSmk+0moCi4n1GTIYsO2qnuTuOUl xKVO4lvprz3fnIHCSHEQ8S+OV+PESz8DjDhhaG9ZLonSQbIGiiP5I9ANEgUc8Vm0pgisF5oz5gp O/P0eN5L0rBOeN084/GohFzCbb7TN5G7YrqRIiihdtF75XtfQcxTAW1ioGkhSxLjn7UxifFzVsq H/mkKMU5+qYcHvc46Z9t8FbUIb79J6F8RHgRnTVa2G0qWp92WsUbTVnGnWJ5FIT+DVKxl5sMHhv cGF34MqunLdgXdfEuyrLzR0xRFqmQZY0RcrJsDiTxRLNHpUE5Y9KJGbBhHz6l0A== X-Google-Smtp-Source: AGHT+IFBa8jscs7YKK6nfWpTRc104v4SBranZgbrtmjczEOEN6GSxdqsX5cxU+BPxsNVHI34R+KuQw== X-Received: by 2002:a17:90b:5246:b0:321:82a0:fe50 with SMTP id 98e67ed59e1d1-3275085dabemr8745800a91.5.1756335893403; Wed, 27 Aug 2025 16:04:53 -0700 (PDT) Received: from google.com (c-73-15-160-255.hsd1.ca.comcast.net. [73.15.160.255]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-327ab0fed32sm329289a91.28.2025.08.27.16.04.52 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 27 Aug 2025 16:04:52 -0700 (PDT) Date: Wed, 27 Aug 2025 16:04:51 -0700 From: Noah Misch To: Andres Freund Cc: Robert Haas , pgsql-hackers@postgresql.org, Melanie Plageman , Thomas Munro , Heikki Linnakangas Subject: Re: Buffer locking is special (hints, checksums, AIO writes) Message-ID: <20250827230451.a4.nmisch@google.com> References: <20250827001449.fb.nmisch@google.com> <20250827191441.1c.nmisch@google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Aug 27, 2025 at 03:29:02PM -0400, Andres Freund wrote: > On 2025-08-27 12:14:41 -0700, Noah Misch wrote: > > On Wed, Aug 27, 2025 at 12:18:27PM -0400, Andres Freund wrote: > > > > On Tue, Aug 26, 2025 at 05:00:13PM -0400, Andres Freund wrote: > > > > > On 2025-08-26 16:21:36 -0400, Robert Haas wrote: > > > > > > On Fri, Aug 22, 2025 at 3:45 PM Andres Freund wrote: > > > > > > > DOES ANYBODY HAVE A BETTER NAME THAN SHARE-EXCLUSIVE???!? > > > Which would leave us with: > > > - reference (pins today) > > > - share > > > - share-exclusive > > > - exclusive > > > - cleanup > > Compared to share-exclusive, I think I'd prefer a name that describes the use > > cases, "set-hints-or-write" (or separate "write" and "set-hints" levels). Another name idea is "self-exclusive", to contrast with "exclusive" excluding all of (exclusive, self-exclusive, share). Fortunately, not much code will acquire this lock type. Hence, there's relatively little damage if the name is less obvious than older lock types or if the name changes later.