Quick Links

SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS

From:	aditya desai <admad123(at)gmail(dot)com>
To:	Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject:	SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS
Date:	2021-04-04 10:42:14
Message-ID:	CAN0SRDH=aG=dM+qyq_zFWacCbAks3ejOdLkp2KYTiQADOHcMpQ@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

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.

Responses

Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS at 2021-04-04 17:01:27 from Amine Tengilimoglu
Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS at 2021-04-04 17:19:45 from Justin Pryzby
Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS at 2021-04-06 15:49:54 from Andrew Dunstan

Browse pgsql-performance by date

	From	Date	Subject
Next Message	aditya desai	2021-04-04 11:10:33	Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Previous Message	Justin Pryzby	2021-04-04 01:25:46	[PATCH] force_parallel_mode and GUC categories