Re: Vacuum message

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Barnard <kevin(dot)barnard(at)gmail(dot)com>
Cc: Pgsql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum message
Date: 2004-11-11 18:56:48
Message-ID: 10248.1100199408@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kevin Barnard <kevin(dot)barnard(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-11 19:01:08 Re: making another super user other than postgres
Previous Message Max 2004-11-11 18:56:46 comp.database.postgresql.*