Postgres Pro
Downloads
Home   >   mailing lists

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

From James Pang
Subject a lot of session wait on lock relation
Date
Msg-id CAHgTRfdEVMi_YVuq3M4R4uARhXQ8ZgkMid3LhxjFbS+Y+Z_8GQ@mail.gmail.com
Whole thread Raw
Responses Re: a lot of session wait on lock relation
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: David Rowley
Date:
Subject: Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
Next
From: Chetan
Date:
Subject: Re: a lot of session wait on lock relation