Re: Vacuum message - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum message
Date
Msg-id 10248.1100199408@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum message  (Kevin Barnard <kevin.barnard@gmail.com>)
Responses Re: Vacuum message
List pgsql-general
Kevin Barnard <kevin.barnard@gmail.com> writes:
> I know I've seen this message before but I'm not quite sure what it
> means.  I think it's because I have two vacuums running over each
> other.  Does this sound right?  It's comming from 7.4.x server.

> ERROR:  tuple concurrently updated

Were they both VACUUM ANALYZEs?  There's a known gotcha that if you
ANALYZE the same table concurrently in two different sessions, one
of them can fail this way when it goes to update the pg_statistic
entries.  (Harmless, but annoying.)  I don't know of any cause for
this message from a plain VACUUM though.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Welty
Date:
Subject: Re: Lionel Lauer 58 Gore Street Fitzroy, Victoria Australia 3065
Next
From: "Max"
Date:
Subject: comp.database.postgresql.*