Re: fyi error follow up - Mailing list pgsql-admin

From Tom Lane
Subject Re: fyi error follow up
Date
Msg-id 21699.1059836472@sss.pgh.pa.us
Whole thread Raw
In response to fyi error follow up  (maillist <maillist@tnss.com>)
List pgsql-admin
maillist <maillist@tnss.com> writes:
> there was a cron job running doing a vacum on the entire database

I was about to say that then it's a known issue --- two ANALYZE
operations running concurrently for the same table can generate
a "simple_heap_insert" or "simple_heap_update" failure from trying
to update the same pg_statistic row at the same time.  This is fairly
harmless (as long as one of 'em succeeds, who cares if the other
doesn't?).

However, looking back at your original message, you said the error
mentioned "simple_heap_delete", didn't you?  Hmm ... how old is your
PG installation?  ANALYZE hasn't used simple_heap_delete since 7.1...

            regards, tom lane

pgsql-admin by date:

Previous
From: maillist
Date:
Subject: fyi error follow up
Next
From: maillist
Date:
Subject: Re: fyi error follow up