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