Postgres Pro
Downloads
Home   >   mailing lists

Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS - Mailing list pgsql-performance

From Andrew Dunstan
Subject Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS
Date
Msg-id 71478dc7-3151-39ed-01ec-15510e8d0adf@dunslane.net
Whole thread Raw
In response to SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS  (aditya desai <admad123@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: select count(*) is slow
Next
From: aditya desai
Date:
Subject: Re: select count(*) is slow