On 4/4/21 6:42 AM, aditya desai wrote: > Hi, > We have few select queries during which we see SHARED LOCKS and > EXCLUSIVE LOCKS on tables. Can these locks cause slowness? Is there > any way to reduce the locks? > > What must be causing ACCESS EXCLUSIVE LOCKS when the application is > running select queries? Is it AUTOVACUUM? >
Suggest you read this part of The Fine Manual: <https://www.postgresql.org/docs/current/explicit-locking.html> cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com
