Re: Too many waits on extension of relation

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

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.