Re: ACCESS EXCLUSIVE lock

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ACCESS EXCLUSIVE lock
Дата
Msg-id 27872.1161190567@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ACCESS EXCLUSIVE lock  (Atesz <atesz@ritek.hu>)
Ответы Re: ACCESS EXCLUSIVE lock  (Atesz <atesz@ritek.hu>)
Список pgsql-performance
Atesz <atesz@ritek.hu> writes:
> My question:  Why need this strict locking?
> In my opinion there isn't exclusion between the DROP CONSTRAINT and the
> SELECT.

This isn't going to be changed, because the likely direction of future
development is that the planner will start making use of constraints
even for SELECT queries.  This means that a DROP CONSTRAINT operation
could invalidate the plan of a SELECT query, so the locking will be
essential.

            regards, tom lane

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: ACCESS EXCLUSIVE lock
Следующее
От: Robert Treat
Дата:
Сообщение: Re: Hints proposal