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 1uoQ9A-003dpD-5H for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Aug 2025 17:29:21 +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 1uoQ99-00FKAO-7u for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Aug 2025 17:29:19 +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 1uoQ98-00FKAG-QV for pgsql-hackers@lists.postgresql.org; Tue, 19 Aug 2025 17:29:19 +0000 Received: from mail-il1-x133.google.com ([2607:f8b0:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uoQ96-000hMy-3B for pgsql-hackers@postgresql.org; Tue, 19 Aug 2025 17:29:18 +0000 Received: by mail-il1-x133.google.com with SMTP id e9e14a558f8ab-3e57002bc23so28058045ab.3 for ; Tue, 19 Aug 2025 10:29:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755624557; x=1756229357; 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=/bUwJ7wGKrdRxdKQnI68qXCcRMV+YrXDQdgEwgVlCVQ=; b=Vqx0Xaks/THjYFMreL5MwHimtSey0Ca8Y9hgMTAEzH26UsPzk8Po19lOqLrOmg8l8F FWxOfzn+FAmF3TftDFpNweGwGPkKPZ84jC9QNsmlKbg8QcSCIcIXR3Dgo6YQ6rTLWNnY +qPbUI5sQiyqBr6P9rIjri04mh7b85dXTIbl04/pwKzg99zk3HdaU8Begm6IuRQDZxQi Sq240RasaDXhVDP5v1aT68KyWBYwcSsMkG2eNQ33tQwDXb+XSGPkfqXOMyJssduRKNcb +C6v6LO+mguMtf+KIjCrLiofK5k0431YeaZs1MQqhWRFPan2g1H3dJemOL7YrtdSkdLs bz+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755624557; x=1756229357; 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=/bUwJ7wGKrdRxdKQnI68qXCcRMV+YrXDQdgEwgVlCVQ=; b=YOHQQ82cVKnGqi7RCIFdMggjeELN7KHkiU/ZLuhwYxSBqTedmBp3t+dqpXWlFkAtTp s3J7j4ygD6cW+VBoYjkp5KxqhWDGixBP4l0A0sOT27MWce6RwkWHKM8agbnULwn5ibDx 7MtPvl1eICY0o5opbp7XtcFsB9uelII8Sp49F2y2GqYb6NGOKSE26iJqSLPMo+Wy2gQk O4Zbr5b2LW19Nf7QmctGt5Bc7Bq5I6yPTVdgj80KVkR+wfzlUVMQ8vPN8LROS/FFLSo+ UI+LVRL3h24qp26wpGx6CHtmf8i5z/abtDhA37A36wLUVbyFxTj1dlSkehcYMEwqIzYh khiw== X-Forwarded-Encrypted: i=1; AJvYcCUl6eyZYq+ggxvHn1pGzMcTMyc/T9VmJgnae+k6oTbj95c2r/4zxrKUChhPyna+847k1PV3ial3wxhKjMhD@postgresql.org X-Gm-Message-State: AOJu0YyiPW8RQIU2/sNljX5BEASeGRS0AlTfk7GQp7YQURlyt91QpHws kitvCHXuWbbKxCH/xjk7t7KDUFtfWjNfKhY0OzhG1y1Vti7+zgVGD/Y3 X-Gm-Gg: ASbGncsqwaz86DaualsGsD4aaNRqvXkD9YpC/uJ6XTjdUkcmtTe5bDdk4mrwBipUZh6 cX/fJMxTQYVVXp7FuOz3nVTbs7s6Z9Iv3Rlqhfl77wYy+h+mVKabMJc2Fid680gz6BomeRLUVTb L0XFn0SeBNEUDOJwvhf9/p+xr+PWdG0plBsZ4wNH0ddVoIIdL7mFgY44/5NnPFZ9YQvO+Kn51c2 AadDjy5sN4BwrLjWdovBGwkmvl1hoWk8nvKe81+wjIBv3zCX8L2L01rPNGDHkeuA0TZAcv90FT/ sdSbij7J8FbXAMIC/GGubcis1USwxCEsfHcD/Eu0s8h8A6tvTG7UcTG9L/d1t/8ewMuHS0s3X6x MbSdTpWOauE17h2EukZTTbrDYxhD67ATvG5cAAWL6IVEONdw5VbwsdH+hJPvVoxT2XIhnFm6LRl 73gni1jIZuRuZXYoqrLKukFFo= X-Google-Smtp-Source: AGHT+IEdWQNfCWXfvmfSwpq7vRsJCgaiM15VwiUeojh7wf3kWg83pcFCc4AeM5eXw5FTptV7ZaTDCQ== X-Received: by 2002:a05:6e02:4805:b0:3e6:7981:1fa8 with SMTP id e9e14a558f8ab-3e679812259mr34416025ab.21.1755624556946; Tue, 19 Aug 2025 10:29:16 -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-3e57e5b73adsm47175255ab.23.2025.08.19.10.29.16 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 19 Aug 2025 10:29:16 -0700 (PDT) Date: Tue, 19 Aug 2025 12:29:14 -0500 From: Nathan Bossart To: Bertrand Drouvot Cc: Sami Imseih , 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 Tue, Aug 19, 2025 at 08:09:53AM +0000, Bertrand Drouvot wrote: > On Mon, Aug 18, 2025 at 05:53:44PM -0500, Sami Imseih wrote: >> > (or some other shmem-based >> > data structure we have yet to introduce, like a dslist/dsarray). >> >> This will be an interesting API to invest time in, if there could be more >> use-cases. > > I did a quick check and I did not find current use cases: possible candidates > could be in ExecParallelHashTableAlloc(), PTIterationArray, PTEntryArray for > examples but I think they all know the final size upfront so there is no real > need for dsarray for those). > >> I think it's a separate discussion at this point. > > OTOH, that would be a valid use case to introduce this new API but I'm not sure > it's worth it given that the dshash looks good enough for our case (even if not > ideal though). IMHO it'd be okay to proceed with dshash for now. It would be pretty easy to switch to something like a "dslist" in the future. -- nathan