Re: Lock conflict

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Lock conflict
Дата
Msg-id CAApHDvpMiNpFeGDrRjozHXFke3VQj0qU41k-_P=8LOxAsSREFw@mail.gmail.com
обсуждение исходный текст
Ответ на Lock conflict  ("席冲(宜穆)" <xichong.xc@alibaba-inc.com>)
Список pgsql-hackers
On Mon, 20 Mar 2023 at 14:58, 席冲(宜穆) <xichong.xc@alibaba-inc.com> wrote:
> I think lock requested only check for conflict with already-held lock, if there is no conflict, the lock should be
granted.

That would mean that stronger locks such as AEL might never be granted
if there was never any moment when no other conflicting locks existed
(which is very likely to happen on busy OLTP-type workloads).  The way
it works now makes it fair so that weaker locks don't jump the queue.

David



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

Предыдущее
От: "席冲(宜穆)"
Дата:
Сообщение: Lock conflict
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Allow logical replication to copy tables in binary format