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 1uj0bs-001cuZ-9C for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Aug 2025 19:12:36 +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 1uj0br-003zb5-8x for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Aug 2025 19:12:35 +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 1uj0bq-003zau-VX for pgsql-hackers@lists.postgresql.org; Mon, 04 Aug 2025 19:12:34 +0000 Received: from mail-il1-x135.google.com ([2607:f8b0:4864:20::135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uj0bo-000jee-1J for pgsql-hackers@postgresql.org; Mon, 04 Aug 2025 19:12:34 +0000 Received: by mail-il1-x135.google.com with SMTP id e9e14a558f8ab-3da73df6b6bso14007265ab.3 for ; Mon, 04 Aug 2025 12:12:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754334753; x=1754939553; 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=f8pSzIIUmWoPA8bg8GfdsnSUtMr6e5E4MXCIIp0N2co=; b=marOqgtz32AXBMr2ARnOS1QIlws7urc3BwR+0aMBSy+Cm0DneLCstyRO9aJzixP/oS LcwS5L3ZZN2ZW3NIELoqdKgzTXAthsQR8L1uTAnkW1S2txqcY610e2SGdEzhE7OGHzZp Qrg+HqAwvvn1ws2mbijAO5UM0LQgRceJTEnqawn2w+l3UirlwsUPAS+ITFvxUqeFEW5V koDSrMYAuSESr40RXpEyoKdaFH6owdHpcQKruRVe8z/2sps05sWI8VQX0kOBFHQhmfPE iQ4PWYrrMdmKfWnP+0Vur22VHW9DHlS9eYXS5IreOrSp3KUb57y5lKpaWAJiGf93DKJo UTUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754334753; x=1754939553; 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=f8pSzIIUmWoPA8bg8GfdsnSUtMr6e5E4MXCIIp0N2co=; b=VDhn64QAWYHkX76TKmzXV66OnSertu3VVScqjn0LguMqnA3QyqAx62OThZWxSptZZ4 PKJ0+uBPL+H4v8pOMBfMOwUTb84i38vCj3uptJLwH9vxO2z1djqthEpoYUntNTiN3r6u rFiyCm4gyImMCV5lOun2QQ8HOaNrE6PTbFv+BY9T3eygzrlrL+Q83k/2F1O3H5invmCI QjtOkVdzH3n3MRibifCJUlYSQoS6rk+O+LD7HRsWrZKWLfEwBL+ag0Xr79cpP+l7zLnH xTzJBYf07WSoVgQj6XX+elFvZgyQ2BtH35DwLhktj5IG4lIkN4cE5GOScQOIykvngDK5 iV6Q== X-Forwarded-Encrypted: i=1; AJvYcCVsCZCMUOeAzjeHflANnlLv+CLP9bKyYBLcVRDz53HCDYd9WSEJotsJBsopG5EZYLXQwS3HRXVtWh8C+aaN@postgresql.org X-Gm-Message-State: AOJu0YzLYKWgkOgkhv+PwGtF4fv8DWdqjfDYIt1nRps9lLizA4cQ1m0L Mb7Ub6n3lz9PKlBUTJ/+Yo50nMWP9eEksgRBTWhVZtKF5SZpA5xyeV/Z1n4GQg== X-Gm-Gg: ASbGncv157AxihXgs+8jV0tQETgHzGnP5rOy0ekJJs73XHmkoSyRMWU2KaIlduMnBLS NDa7ZWGMRz0U0/mKVDNH28yU2sMX4rzMU+PiHz+fbeeYBAYrGKwPb2/Cqid3XJMUQQ6vwlZBM3E HZRJ6fY16432VW6VFS0KqiCnMY7NUCUXTvXfuNPVb7WPeAgyf/keCsumwRh+En3SdA9A06y0lnT QfbEpIaK0BHqGtytXQB1PI9EQF+UzdSXpLInKMoAo230g7VxOQIZk9oj8xbK803kJ21Uk9wDue9 +mjeL1HjOsL6sDqu0FlI7PMGr5c6kJWnyOHKK/d0Na7CisMQ5Bd1iVacG2FWDp9uzlwwC7vwrXx JH3v037J2dNYNjyYVMDxywoC0e8YlGrdcTedDSKt+WogJkKyLlyk7RwemfeKKCC5qOqyTHzVkzW 9i8YzJfbRt2krT X-Google-Smtp-Source: AGHT+IE9naZllCoewAH102rrTYGPCqehkS0CCHHuMHIF5l8SGxvAQkadUei3GFdH7vLXcJ/Wcs3+pQ== X-Received: by 2002:a92:cb86:0:b0:3e2:9f1e:e291 with SMTP id e9e14a558f8ab-3e4161cec37mr161569745ab.21.1754334752629; Mon, 04 Aug 2025 12:12:32 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3e4029d41a6sm43638935ab.24.2025.08.04.12.12.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 04 Aug 2025 12:12:32 -0700 (PDT) Date: Mon, 4 Aug 2025 14:12:30 -0500 From: Nathan Bossart To: Sami Imseih Cc: Bertrand Drouvot , 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 Mon, Aug 04, 2025 at 11:32:19AM -0500, Sami Imseih wrote: > With a local hash table, I don't think it's necessary to introduce new > code for managing > a DSA based list of tranche names as is done in v3. We can go back to > storing the shared > trance names in dshash. > > What do you think? My first thought is that a per-backend hash table seems too expensive/complicated for this. Couldn't it just be an array like we have now? -- nathan