MIME-Version: 1.0
References: 
 <CAHgTRfdEVMi_YVuq3M4R4uARhXQ8ZgkMid3LhxjFbS+Y+Z_8GQ@mail.gmail.com>
In-Reply-To: 
 <CAHgTRfdEVMi_YVuq3M4R4uARhXQ8ZgkMid3LhxjFbS+Y+Z_8GQ@mail.gmail.com>
From: Chetan <chetansuttraway@gmail.com>
Date: Thu, 15 May 2025 10:31:12 +0100
Message-ID: 
 <CAHAB5PZDSofqCQgvGB_TnfYRtyNHxs_d70+BEuOx=psasZ9EqQ@mail.gmail.com>
Subject: Re: a lot of session wait on lock relation
To: James Pang <jamespang886@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d1eccc0635295566"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHAB5PZDSofqCQgvGB_TnfYRtyNHxs_d70%2BBEuOx%3DpsasZ9EqQ%40mail.gmail.com>
Precedence: bulk

--000000000000d1eccc0635295566
Content-Type: text/plain; charset="UTF-8"

Hi James,

Could share the related test setup details?
Would like to look into this.

Thanks,
Chetan


On Thu, 15 May 2025 at 09:27, James Pang <jamespang886@gmail.com> wrote:

> Hi,
>    PGv 15.10,  many session coming in doing "insert into tablexxx
> values...." in parallel, this is a range partition tables, total 12
> partitions plus one default partition, only three btree indexes, no others
> constraints ,no foreign key. but we see hundreds of session waiting on
> "lock:relation", why inserts into partition table cause "relation lock" ?
>
> Thanks,
>
> James
>


-- 
-- 
Regards,
Chetan

+353899475147
+919665562626

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

<div dir=3D"ltr">Hi James,<div><br></div><div>Could share the related test =
setup details?=C2=A0</div><div>Would like to look into this.</div><div><br>=
</div><div>Thanks,</div><div>Chetan</div><div><br></div></div><br><div clas=
s=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_att=
r">On Thu, 15 May 2025 at 09:27, James Pang &lt;<a href=3D"mailto:jamespang=
886@gmail.com">jamespang886@gmail.com</a>&gt; wrote:<br></div><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi,<div>=C2=A0 =C2=A0=
PGv 15.10,=C2=A0 many session coming in doing &quot;insert into tablexxx va=
lues....&quot; in parallel, this is a range partition tables, total 12 part=
itions plus one default partition, only three btree indexes, no others cons=
traints ,no foreign key. but we see hundreds=C2=A0of session waiting on &qu=
ot;lock:relation&quot;, why inserts into partition table cause &quot;relati=
on lock&quot; ?=C2=A0</div><div><br></div><div>Thanks,</div><div><br></div>=
<div>James</div></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div dir=3D"ltr">-- <br>Re=
gards,<br>Chetan<br><br>+353899475147<br>+919665562626<br><br></div></div><=
/div></div></div>

--000000000000d1eccc0635295566--