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 <jamespang...@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