Re: ANALYZE error - Mailing list pgsql-sql

From Tom Lane
Subject Re: ANALYZE error
Date
Msg-id 20428.1078808149@sss.pgh.pa.us
Whole thread Raw
In response to ANALYZE error  ("David Witham" <davidw@unidial.com.au>)
List pgsql-sql
"David Witham" <davidw@unidial.com.au> writes:
> Occasionally I get this error message from the analyze job:
> ERROR:  simple_heap_update: tuple concurrently updated
> What does this mean and should I do anything about it?

You can get this if two ANALYZEs run in parallel for the same table;
whichever one tries to update pg_statistic second fails with the above
error.  It's moderately annoying, but not dangerous.
        regards, tom lane


pgsql-sql by date:

Previous
From: "David Witham"
Date:
Subject: ANALYZE error
Next
From: "Iain"
Date:
Subject: Re: ANALYZE error