Re: What does "tuple concurrently updated" mean?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What does "tuple concurrently updated" mean?
Дата
Msg-id 21177.1114448570@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: What does "tuple concurrently updated" mean?  ("Florian G. Pflug" <fgp@phlo.org>)
Ответы Re: What does "tuple concurrently updated" mean?  ("Florian G. Pflug" <fgp@phlo.org>)
Список pgsql-general
"Florian G. Pflug" <fgp@phlo.org> writes:
> So - does "tuple concurrently updated" make sense for "analyze"?

Yeah, it's entirely possible, if you have a background process that
might issue analyzes too (do you use autovacuum?).  The error comes when
two sessions concurrently try to update the same row in pg_statistic.
I've looked at preventing it, but the cure seems worse than the disease
--- we don't really want ANALYZE to take any strong locks on the table,
and in any case all you are losing is presumably-near-duplicate stats
from one session or the other.

            regards, tom lane

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

Предыдущее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: What does "tuple concurrently updated" mean?
Следующее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: What does "tuple concurrently updated" mean?