Re: 'tuple concurrently updated' error for alter role ... set

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 'tuple concurrently updated' error for alter role ... set
Дата
Msg-id 12194.1305241163@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 'tuple concurrently updated' error for alter role ... set  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: 'tuple concurrently updated' error for alter role ... set  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, May 12, 2011 at 6:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> We're not likely to do that, first because it's randomly different from
>> the handling of every other system catalog update,

> We have very robust locking of this type for table-related DDL
> operations and just about none for anything else.  I don't consider
> the latter to be a feature.

I didn't say it was ;-).  What I *am* saying is that if we're going to
do anything about this sort of problem, there needs to be a
well-considered system-wide plan.  Arbitrarily changing the locking
rules for individual operations is not going to make things better,
and taking exclusive locks on whole catalogs is definitely not going to
make things better.
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: 'tuple concurrently updated' error for alter role ... set
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: SSI-related code drift between index_getnext() and heap_hot_search_buffer()