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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1scphb-00AnRh-6M
	for pgsql-general@arkaria.postgresql.org; Sat, 10 Aug 2024 17:16:27 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1scphZ-009oLf-D3
	for pgsql-general@arkaria.postgresql.org; Sat, 10 Aug 2024 17:16:25 +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 <xof@thebuild.com>)
	id 1scphZ-009oLX-0J
	for pgsql-general@lists.postgresql.org; Sat, 10 Aug 2024 17:16:25 +0000
Received: from smtp89.iad3a.emailsrvr.com ([173.203.187.89])
	by makus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1scphS-0044In-Nk
	for pgsql-general@lists.postgresql.org; Sat, 10 Aug 2024 17:16:23 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp4.relay.iad3a.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 5C6BA4278;
	Sat, 10 Aug 2024 13:16:17 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Soluton on Lock:extend issue
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CAJCZkoKUW18gbPu00W4WHXsBDM+7GvPiah1s-W+gKV41DpYbDw@mail.gmail.com>
Date: Sat, 10 Aug 2024 10:15:46 -0700
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <A3395DA5-BABE-443B-819F-F39EB409B235@thebuild.com>
References: <CAJCZkoKUW18gbPu00W4WHXsBDM+7GvPiah1s-W+gKV41DpYbDw@mail.gmail.com>
To: Durgamahesh Manne <maheshpostgres9@gmail.com>
X-Mailer: Apple Mail (2.3774.600.62)
X-Classification-ID: 7822ed46-1cab-43f2-9bf3-fb2435137948-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/A3395DA5-BABE-443B-819F-F39EB409B235%40thebuild.com>
Precedence: bulk



> On Aug 10, 2024, at 09:52, Durgamahesh Manne =
<maheshpostgres9@gmail.com> wrote:
> Lock:extend  (version 14.11)

PostgreSQL version 16 contains improvements that significantly reduce =
the amount of contention on extend locks; upgrading will almost =
certainly help.=