Re: a lot of session wait on lock relation - Mailing list pgsql-performance

From Chetan
Subject Re: a lot of session wait on lock relation
Date
Msg-id CAHAB5PZDSofqCQgvGB_TnfYRtyNHxs_d70+BEuOx=psasZ9EqQ@mail.gmail.com
Whole thread Raw
In response to a lot of session wait on lock relation  (James Pang <jamespang886@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: James Pang
Date:
Subject: a lot of session wait on lock relation
Next
From: Tom Lane
Date:
Subject: Re: a lot of session wait on lock relation