public inbox for [email protected]
help / color / mirror / Atom feedSoluton on Lock:extend issue
2+ messages / 2 participants
[nested] [flat]
* Soluton on Lock:extend issue
@ 2024-08-10 16:52 Durgamahesh Manne <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Durgamahesh Manne @ 2024-08-10 16:52 UTC (permalink / raw)
To: [email protected]; [email protected]; Christoph Berg <[email protected]>; Koichi Suzuki <[email protected]>; Koichi Suzuki <[email protected]>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Soluton on Lock:extend issue
@ 2024-08-10 17:15 Christophe Pettus <[email protected]>
parent: Durgamahesh Manne <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Christophe Pettus @ 2024-08-10 17:15 UTC (permalink / raw)
To: Durgamahesh Manne <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]>
> On Aug 10, 2024, at 09:52, Durgamahesh Manne <[email protected]> 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-08-10 17:15 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-10 16:52 Soluton on Lock:extend issue Durgamahesh Manne <[email protected]>
2024-08-10 17:15 ` Christophe Pettus <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox