MIME-Version: 1.0
References: 
 <CAHgTRfesRFm1BuG_5guvdSCof2qoHGZvaa1YEkim97EMALaWgQ@mail.gmail.com>
 <CAGPeHmiuURaY4K=Kj6uktbiKBt-cGPFpH-2Vvb90ZgnB0TAXwA@mail.gmail.com>
In-Reply-To: 
 <CAGPeHmiuURaY4K=Kj6uktbiKBt-cGPFpH-2Vvb90ZgnB0TAXwA@mail.gmail.com>
From: kyle Hailey <kylelf@gmail.com>
Date: Sat, 8 Feb 2025 11:41:18 -0800
Message-ID: 
 <CADsdiQjTrkn8RNSu-exzRynyEt9N_1yAjw9L8nXSGDVS5QRuRA@mail.gmail.com>
Subject: Re: lwlock:LockManager wait_events
To: SAMEER KUMAR <sameer.kasi200x@gmail.com>
Cc: James Pang <jamespang886@gmail.com>,
 pgsql-performance@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e16a29062da6aa98"
Archived-At: 
 <https://www.postgresql.org/message-id/CADsdiQjTrkn8RNSu-exzRynyEt9N_1yAjw9L8nXSGDVS5QRuRA%40mail.gmail.com>
Precedence: bulk

--000000000000e16a29062da6aa98
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

late to the game here but this might be of interest:

https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlockl=
ockmanager-scalability/


On Fri, Oct 25, 2024 at 5:10=E2=80=AFAM SAMEER KUMAR <sameer.kasi200x@gmail=
.com>
wrote:

>
>
> On Fri, 25 Oct 2024, 14:36 James Pang, <jamespang886@gmail.com> wrote:
>
>> experts,
>>     we faced into a lot of  lwlock:LockManager wait-events , all of thes=
e
>> queries are "select ..." ,  there are other several session are doing DM=
L,
>> insert/update/delete on same table.   Did these DML transactions holding
>> "transactionid" and "tuple" lock blocking "select" on lwlock:LockManager=
 ?
>>
>
>
> Which version of PostgreSQL?
> Are these all same query or variant of same query (with different
> parameters)?
>
> What's the schema (you can redact column names) for the tables involved i=
n
> the select query which is blocked/waiting on lock_manager?
>
>
>> Thanks,
>>
>> James
>>
>

--000000000000e16a29062da6aa98
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br><div>late to the game here but this might be of intere=
st:</div><div><br></div><div><a href=3D"https://ardentperf.com/2024/03/03/p=
ostgres-indexes-partitioning-and-lwlocklockmanager-scalability/">https://ar=
dentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager=
-scalability/</a></div><div><br></div><div><br></div><div><br></div><div><b=
r></div></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=
=3D"ltr" class=3D"gmail_attr">On Fri, Oct 25, 2024 at 5:10=E2=80=AFAM SAMEE=
R KUMAR &lt;<a href=3D"mailto:sameer.kasi200x@gmail.com">sameer.kasi200x@gm=
ail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><div dir=3D"auto"><div><br><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Fri, 25 Oct 2024, 14:36 James Pang, &lt;<a=
 href=3D"mailto:jamespang886@gmail.com" target=3D"_blank">jamespang886@gmai=
l.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:=
1ex"><div dir=3D"ltr">experts,<div>=C2=A0 =C2=A0 we faced into a lot of=C2=
=A0 lwlock:LockManager wait-events , all of these queries=C2=A0are &quot;se=
lect ...&quot; ,=C2=A0 there are other several session are doing DML, inser=
t/update/delete on same table.=C2=A0 =C2=A0Did these DML transactions holdi=
ng &quot;transactionid&quot; and &quot;tuple&quot; lock blocking=C2=A0&quot=
;select&quot; on lwlock:LockManager ?=C2=A0=C2=A0</div></div></blockquote><=
/div></div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=
=3D"auto">Which version of PostgreSQL?</div><div dir=3D"auto">Are these all=
 same query or variant of same query (with different parameters)?=C2=A0</di=
v><div dir=3D"auto"><br></div><div dir=3D"auto">What&#39;s the schema (you =
can redact column names) for the tables involved in the select query which =
is blocked/waiting on lock_manager?=C2=A0</div><div dir=3D"auto"><br></div>=
<div dir=3D"auto"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex"><div dir=3D"ltr"><div><br></div><div>Thanks,</div><div>=
<br></div><div>James</div></div>
</blockquote></div></div></div>
</blockquote></div>

--000000000000e16a29062da6aa98--