a lot of session wait on lock relation

James Pang <jamespang886@gmail.com>

From: James Pang <jamespang886@gmail.com>
To: pgsql-performance@lists.postgresql.org
Date: 2025-05-15T08:27:31Z
Lists: pgsql-performance
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