Postgres Pro
Downloads
Home   >   mailing lists

Thread: Soluton on Lock:extend issue

Soluton on Lock:extend issue

From
Durgamahesh Manne
Date:
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 

Re: Soluton on Lock:extend issue

From
Christophe Pettus
Date:

> 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;
upgradingwill almost certainly help.