Soluton on Lock:extend issue

Started by Durgamahesh Manneover 1 year ago2 messagesgeneral
Jump to latest
#1Durgamahesh Manne
maheshpostgres9@gmail.com

Hi

Lock:extend (version 14.11)
How to resolve lock:extend issue even there is surge in concurrent sessions
(insert and update) on same table

Reduction on concurrent sessions would be solved but that is not a solution
and
there is no network bandwidth issue

Is there any parameter to tune to minimize the impact on lock:extend ?

Regards,
Durga Mahesh

#2Christophe Pettus
xof@thebuild.com
In reply to: Durgamahesh Manne (#1)
Re: Soluton on Lock:extend issue

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.