| Lists: | pgsql-generalPostg배트맨 토토SQL : |
|---|
| From: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org, Christoph Berg <myon(at)debian(dot)org>, Koichi Suzuki <koichi(dot)dbms(at)gmail(dot)com>, Koichi Suzuki <koichidbms(at)gmail(dot)com> |
| Subject: | Soluton on Lock:extend issue |
| Date: | 2024-08-10 16:52:39 |
| Message-ID: | CAJCZkoKUW18gbPu00W4WHXsBDM+7GvPiah1s-W+gKV41DpYbDw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-in-general |
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
| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Soluton on Lock:extend issue |
| Date: | 2024-08-10 17:15:46 |
| Message-ID: | A3395DA5-BABE-443B-819F-F39EB409B235@thebuild.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general Postg배트맨 토토SQL : |
> On Aug 10, 2024, at 09:52, Durgamahesh Manne <maheshpostgres9(at)gmail(dot)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.