Обсуждение: Meaning of ERROR: tuple concurrently updated

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

KÖPFERL Robert <robert.koepferl@sonorys.at> writes:
> Thus I run VACUUM ANALYZE; every night by cron. However I keep getting
> ERROR:  tuple concurrently updated

Have you got other processes also doing VACUUM ANALYZE?  The only known
reason for this to happen is that two processes concurrently ANALYZE the
same table and conflict when they both try to update the same
pg_statistic rows.
        regards, tom lane