Meaning of ERROR: tuple concurrently updated - Mailing list pgsql-sql

From KÖPFERL Robert
Subject Meaning of ERROR: tuple concurrently updated
Date
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB166FF@neptun.sonorys.at
Whole thread Raw
Responses Re: Meaning of ERROR: tuple concurrently updated  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hi,
I have got some kind of FIFO-queue table.
New records are inserted and the oldest are DELETEd.

Thus I run VACUUM ANALYZE; every night by cron. However I keep getting
ERROR:  tuple concurrently updated
My research lead me to the point that this is VACUUM tothether with the
INSERTs being issued to that table all the time.
But I didn't find a solution to avoid this. AFAIK now the table never gets
VACUUMed at all?

Please, what's really about that, how can it be avoided?


Thanks in advance


pgsql-sql by date:

Previous
From: Alain
Date:
Subject: Changed to: how to solve the get next 100 records problem
Next
From: Tom Lane
Date:
Subject: Re: Meaning of ERROR: tuple concurrently updated