Re: group locking: incomplete patch, just for discussion

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: group locking: incomplete patch, just for discussion
Дата
Msg-id 7595.1415908218@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: group locking: incomplete patch, just for discussion  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: group locking: incomplete patch, just for discussion  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Nov 13, 2014 at 3:38 AM, Jeff Davis <pgsql@j-davis.com> wrote:
>> If two backends both have an exclusive lock on the relation for a join
>> operation, that implies that they need to do their own synchronization,
>> because obviously the lock manager is not doing it for them.

> This doesn't make sense to me.  Why would they need to synchronize
> access to a relation in order to join it?

What's more to the point: why would you take an exclusive lock just to
do a join?
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: alter user/role CURRENT_USER