Home > mailing lists

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

From	aditya desai
Subject	SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS
Date	April 4, 2021 13:42:14
Msg-id	CAN0SRDH=aG=dM+qyq_zFWacCbAks3ejOdLkp2KYTiQADOHcMpQ@mail.gmail.com Whole thread Raw
Responses	Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS
List	pgsql-performance

Tree view

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?

Regards,

Aditya.

pgsql-performance by date:

From: Pavel Stehule
Date: 03 April 2021, 20:50:38
Subject: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.

From: aditya desai
Date: 04 April 2021, 14:10:33
Subject: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.

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

Previous

Next