SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS

Поиск
Список
Период
Сортировка
От aditya desai
Тема SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS
Дата
Msg-id CAN0SRDH=aG=dM+qyq_zFWacCbAks3ejOdLkp2KYTiQADOHcMpQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS  (Amine Tengilimoglu <aminetengilimoglu@gmail.com>)
Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS  (Justin Pryzby <pryzby@telsasoft.com>)
Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS  (Andrew Dunstan <andrew@dunslane.net>)
Список 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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Следующее
От: aditya desai
Дата:
Сообщение: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.