MIME-Version: 1.0
From: James Pang <jamespang886@gmail.com>
Date: Thu, 15 May 2025 16:27:31 +0800
Message-ID: 
 <CAHgTRfdEVMi_YVuq3M4R4uARhXQ8ZgkMid3LhxjFbS+Y+Z_8GQ@mail.gmail.com>
Subject: a lot of session wait on lock relation
To: pgsql-performance@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000006da4be0635287070"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHgTRfdEVMi_YVuq3M4R4uARhXQ8ZgkMid3LhxjFbS%2BY%2BZ_8GQ%40mail.gmail.com>
Precedence: bulk

--0000000000006da4be0635287070
Content-Type: text/plain; charset="UTF-8"

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

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

<div dir=3D"ltr">Hi,<div>=C2=A0 =C2=A0PGv 15.10,=C2=A0 many session coming =
in doing &quot;insert into tablexxx values....&quot; in parallel, this is a=
 range partition tables, total 12 partitions plus one default partition, on=
ly three btree indexes, no others constraints ,no foreign key. but we see h=
undreds=C2=A0of session waiting on &quot;lock:relation&quot;, why inserts i=
nto partition table cause &quot;relation lock&quot; ?=C2=A0</div><div><br><=
/div><div>Thanks,</div><div><br></div><div>James</div></div>

--0000000000006da4be0635287070--