Re: fyi error follow up

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: maillist <maillist(at)tnss(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: fyi error follow up
Date: 2003-08-02 15:01:12
Message-ID: 21699.1059836472@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

maillist <maillist(at)tnss(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message maillist 2003-08-02 17:40:39 Re: fyi error follow up
Previous Message maillist 2003-08-02 13:20:05 fyi error follow up