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 1us1YI-00GHEx-4r for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Aug 2025 16:02:11 +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 1us1YH-00Awch-IB for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Aug 2025 16:02:10 +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 1us1YH-00AwcA-87 for pgsql-hackers@lists.postgresql.org; Fri, 29 Aug 2025 16:02:09 +0000 Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1us1YF-002OOZ-0P for pgsql-hackers@postgresql.org; Fri, 29 Aug 2025 16:02:08 +0000 Received: by mail-io1-xd2b.google.com with SMTP id ca18e2360f4ac-88432e27c77so78135239f.2 for ; Fri, 29 Aug 2025 09:02:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1756483327; x=1757088127; 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=pnimg5Wml2bN9P3oMjVSAdrmApfCRn8cnckIAK6NT4A=; b=NK+/pkN/NKFRjnGA1e6XGgKUxWwciddn63PD7bWumWWEGw8ZgRJTSD0Y26MqCtQ4ML SWgOy4b0KJcydgEmtklz89zLtLy9sfXUStf7vEVMPGscQ66m6I6jEoxzFB310I3QjXoY FXXPcDuYYCqZgH2zNVUt/xspbLDw1kopstrANCQmSX0yj1pOsBG2suSitwLxJFhrtHfu 7y81MhiFBiFXUtzZhASelg3+mqiaJgjq6X7LhRQyCh+TjqBTPmGhy7Aye54NZrHtwZSb zb05Guqsec6p7bbNonNHz6aPXs5vR67jOI3jrvUtBBM4DyHHgA7oasUMsElVVXF19zjh 3N8w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756483327; x=1757088127; 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=pnimg5Wml2bN9P3oMjVSAdrmApfCRn8cnckIAK6NT4A=; b=JdvcBkDErPBRh+ZfiHkSB1ICyonfvTJXMtXz6TCYXPrn882SX7+uX2LKQb1j9yFIOX d2n4Ln3XXPWrSn8SETfwS2hcFF4PXWMkrH+N9y9t0nb2AMupcpIoaGtxbRK2b/Is6QLJ iLRiGsAkgOQDS7YaK3/PuJvYfg+m1yX5t70CmwEn3ucHr3nValua83lkE/cRG4vnsICf UIlhQLZPXc8FAPZySsl/0svpT1s4KaCJ160Xq6tLeMbs5H+0lH71sUVe4fIofw2lsvxE IVaSlGok3ai0P9XzjImsbR+gWk90tBO8a+eZ/oKIV2zKOS3Hd6GqJ9pfHeDT4uhy4uJX k6TQ== X-Forwarded-Encrypted: i=1; AJvYcCWZxTE2QsoeBG6Cz0pLpuUoS4SxEW+rEbNU4zi8wJ6dWjzmL63GJS2mhJSCVFWTtlRly7j1IW693JNslhYq@postgresql.org X-Gm-Message-State: AOJu0YxbAf2lHwx/3tobgXtPUIiFRwCxKd1iO9iitnWzqG1QDhrube+c WRsEaoY/G1EHDVXkOdLq0sQTVRyvfhmPNuhudFvQAd6a8VS80zy+1EMn X-Gm-Gg: ASbGncsYGlvVrtBsq1XL55gxNuD7vvnJMz+P3CKxHm0RR/9EnDCHER5mHU8lLt6s4l6 BJop0OWtvarUJWTswyjXlG91zkQ92YoQxYJOuMmIomfr1zRC/s8M9iTMEbzfB67yEzmG4KEQaFx rUikhQVlt2jIXwUCSLn9Z2gQZAb785xkKjBBMjcX9plhGx3OXjcnKGVeOZNwtnCgxZOZD5g4XmP B06fk10fMlEfB8c3lHEXciechhzRRuS2LokTU+ZAHWQfwyPJLlu2NstA0dk00V5MyQnlHkgRSp9 NxYLihLZYelgt65ORMATibUcE41vMX2H8SE+gMor2Z3trXB4lw/909KnC4oeB0jeKgGIqQYL+FQ qkSAZ/fZvASCNA589HI7QI8WVFSG6Th5iBIo3PNuRkaGy4yjG7KygotnrsYI5sYzN9g290y92co ESlFTIgPC0ld1g X-Google-Smtp-Source: AGHT+IHetOl7jjMwM1vxFF+Si7ydnonXu04A33pCY7kWZ1HvSWcVYfRcrM4mZpFJmB+fBNxnn9ikLg== X-Received: by 2002:a05:6e02:3c03:b0:3e6:7b31:bd71 with SMTP id e9e14a558f8ab-3e9223163cdmr432701215ab.19.1756483325256; Fri, 29 Aug 2025 09:02:05 -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-50d7be3e6d7sm658410173.26.2025.08.29.09.02.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 29 Aug 2025 09:02:04 -0700 (PDT) Date: Fri, 29 Aug 2025 11:02:02 -0500 From: Nathan Bossart To: Sami Imseih Cc: Bertrand Drouvot , Tom Lane , Andres Freund , Rahila Syed , pgsql-hackers Subject: Re: Improve LWLock tranche name visibility across backends Message-ID: References: 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 On Thu, Aug 28, 2025 at 05:53:23PM -0500, Sami Imseih wrote: >> I think this patch set will require reworking the "GetNamedLWLockTranche >> crashes on Windows in normal backend" patch [0], but AFAICT we can easily >> adjust it to scan through NamedLWLockTrancheNames instead. > > Except, we will need to turn the char**NamedLWLockTranche into a struct > that will hold the num_lwlocks as well. Something like. But that is doable. Ah, right. > If there is no interest to backpatch [0], maybe we should just make this > change as part of this patch set. What do you think? I can make this change > in v18. I think we should keep that separate. I don't see any benefit to combining it, and it'd be good to keep the discussion in a single thread in the archives for future reference. -- nathan