[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS
From:       Andrew Dunstan <andrew () dunslane ! net>
Date:       2021-04-06 15:49:54
Message-ID: 71478dc7-3151-39ed-01ec-15510e8d0adf () dunslane ! net
[Download RAW message or body]


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



[prev in list] [next in list] [prev in thread] [next in thread]