a lot of session wait on lock relation

From: James Pang <jamespang886(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: a lot of session wait on lock relation
Date: 2025-05-15 08:27:31
Message-ID: CAHgTRfdEVMi_YVuq3M4R4uARhXQ8ZgkMid3LhxjFbS+Y+Z_8GQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Chetan 2025-05-15 09:31:12 Re: a lot of session wait on lock relation
Previous Message Pavel Stehule 2025-05-15 06:48:37 Re: Re: proposal: schema variables