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

From Tom Lane
Subject Re: Meaning of ERROR: tuple concurrently updated
Date
Msg-id 22416.1116432003@sss.pgh.pa.us
Whole thread Raw
In response to Meaning of ERROR: tuple concurrently updated  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Meaning of ERROR: tuple concurrently updated
Next
From: "Felix E. Klee"
Date:
Subject: Turning column into *sorted* array?