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 1uoR7U-003udf-76 for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Aug 2025 18:31:41 +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 1uoR7T-00GEVW-8h for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Aug 2025 18:31:39 +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 1uoR7S-00GEVN-Vh for pgsql-hackers@lists.postgresql.org; Tue, 19 Aug 2025 18:31:39 +0000 Received: from mail-oi1-x22d.google.com ([2607:f8b0:4864:20::22d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uoR7R-000hwf-0y for pgsql-hackers@postgresql.org; Tue, 19 Aug 2025 18:31:38 +0000 Received: by mail-oi1-x22d.google.com with SMTP id 5614622812f47-435de81b368so2542365b6e.3 for ; Tue, 19 Aug 2025 11:31:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755628297; x=1756233097; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=2SxMJhxYuQh9doE+e9RetI5bEGZ01lUDvZsC3hf5WEs=; b=UvVsfe//aFSIlWvH4OmFEmr3yzDdkynqi0SR/d4QMiQEB9evJjKaGa9upldKAkeJ0N H0++rnOXk//s0rFpJOr6fqPC7yCm07x+7FehQWctA7awB4wHWisneGrDlw366bZiKnMM yGsCywbBOx3cZhpHjolWhDkH4tRm4pa++YhC5OWEoXofe+AmA2nFTirQ0Tf3e2M8eIag gm3p+KIknT+lSoEA2Gf0ig7/FE+vmOvpQi5gf8oE21pzgPmTEjb1aOiDx239ypm6QENf 3zD51B4vUTU4PeaKSW/uXoe0+k6QGIG34t3/vtLuOqPaGkYVNz6JSiR9E/yQVdawM4mC WRDg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755628297; x=1756233097; h=in-reply-to: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=2SxMJhxYuQh9doE+e9RetI5bEGZ01lUDvZsC3hf5WEs=; b=UxBnxSHU9bloOtSZBxinycJDUMlZbc0wBkfJ4Zqjj9Kd9W3sQ6HFiEeJsU4R//4mxg M90bvZrAoWoV6QnyrEeGiW5cLlXGYsO72VrCeOCi8XeqsUrzP5ceOm5wk8wr+sUO+Xth kGMs9QJACEUnH39VdXv9Zma0c8atLV+utfROrCbyjeLA2ltciAMb9JXL08lb1Ak/pikW lx3lCjGbwOcg1Hd1MvCwwPqqc4NlHLRavaecZi9pKX51sXRy91vDtQ3EE4/eyP1slkPq D4REq9yR+dhM0sdmDlZhc416g+3KJ5h0TZAOrGTXoROom05WuICrDb1FszCq668HysIb FLVg== X-Forwarded-Encrypted: i=1; AJvYcCXC0y5FXthW10wtxuMHyakd6drcTAH6WYp3WMiXoMJ23+WwwVBvH70z0HIpamgTgKmpBraaittMG06lijLw@postgresql.org X-Gm-Message-State: AOJu0Yy0utEHGPW3j5TvGovkp+/tk81MP/LFUPetoKz9Yd7a0LAZFBnu wcEm6ERivNdyGAkee2SgxA0I+OR/Xgl7IqXQ3sVRgl9KiVP/NObM2fP1 X-Gm-Gg: ASbGncsZ6+zx4Zo4hUeWsB5aNEAecK/PYEEx9ZFb4HSLg04+AKDxq3qhmVW/Q0O5ypT Rrdk5WHrTLR8iTZa+B4oLMoIl0S+7OV7K+RuWmurTqlEbt8v4EzA6MstlwVcmBx4elXt8g5v7vY chmu+cgxg2KZnPY89cK5fwSFW/B2R/+HwB4c/VTTUx8/jO7C2BvPI0o5Pog+vz90q4KprXPhSYO RSr5Iea3RAM2uRaLHmPLZTZhMTPGlBpYM9evXJfhaz+7h8eRgf6mNR5SuxiR0xdgk+HmcGrkT7W YaSu+Gyian9y8M7YbGFMkJfSUNqkjmorspSstOS1s3vgBD/+LAXzN3Z+Cvv6q2gnCRwI7w+js6j OcKq32nJeaIgg8/VpaAtZy5Oue5A0buh+uLCpSYTiWd5FtWSaNeKYoh/r3+duGhE2lp0BOF0Yet 4Kh0as4m7w+lVY X-Google-Smtp-Source: AGHT+IGSRH1WgLFqdUZTINiJs9dB6+iK6AwnNSTxQg6VPEGQWi8+cLCkRyXNJkIWQVWFN3vj885Y0A== X-Received: by 2002:a05:6808:199d:b0:406:6e89:499f with SMTP id 5614622812f47-436da4055dbmr2305643b6e.35.1755628297369; Tue, 19 Aug 2025 11:31:37 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-50c947b40e4sm3533561173.30.2025.08.19.11.31.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 19 Aug 2025 11:31:36 -0700 (PDT) Date: Tue, 19 Aug 2025 13:31:35 -0500 From: Nathan Bossart To: Andres Freund Cc: Bertrand Drouvot , Sami Imseih , Rahila Syed , pgsql-hackers Subject: Re: Improve LWLock tranche name visibility across backends Message-ID: References: <34drxi6kshtzu5aerftjflrm6wfxxw54emyvy4gqemdpxxuhvm@gymw6its72o7> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <34drxi6kshtzu5aerftjflrm6wfxxw54emyvy4gqemdpxxuhvm@gymw6its72o7> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Aug 19, 2025 at 02:06:50PM -0400, Andres Freund wrote: > Possibly stupid question - is it really worth having a dynamic structure here? > The number of tranches is strictly bound, it seems like it'd be simpler to > have an array of tranch nmes in shared memory. Tranches can be allocated post-startup with LWLockNewTrancheId() (e.g., autoprewarm). -- nathan