Re: What does "tuple concurrently updated" mean? - Mailing list pgsql-general

From Tom Lane
Subject Re: What does "tuple concurrently updated" mean?
Date
Msg-id 21177.1114448570@sss.pgh.pa.us
Whole thread Raw
In response to Re: What does "tuple concurrently updated" mean?  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: What does "tuple concurrently updated" mean?  ("Florian G. Pflug" <fgp@phlo.org>)
List 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 by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: What does "tuple concurrently updated" mean?
Next
From: "Florian G. Pflug"
Date:
Subject: Re: What does "tuple concurrently updated" mean?