Re: Too many waits on extension of relation

2020-10-05 Thread avinash varma
Hi Michael, Yes, All the locks are of type= extend. Is there a way where we can improve the performance of concurrent inserts on the same table. Thanks, Avinash

Too many waits on extension of relation

2020-10-05 Thread avinash varma
Hi Team, Can someone please guide me how to improve/reduce these wait events. Postgres Version:9.5 LOG: process 3718 still waiting for ExclusiveLock on extension of relation 266775 of database 196511 after 1000.057 ms *Detail:* Process holding the lock: 6423. Wait queue: 3718, 4600, 2670, 4046.