On Thu, 2025-05-15 at 16:27 +0800, James Pang wrote:
> 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" ?

Something else does; use the pg_blocking_pids() function with the process ID of
a blocked backend to find out who is holding the lock.

If you have hundreds of sessions, you are allowing to many connections.

Yours,
Laurenz Albe


Reply via email to