Re: fyi error follow up

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: fyi error follow up
Дата
Msg-id 21699.1059836472@sss.pgh.pa.us
обсуждение исходный текст
Ответ на fyi error follow up  (maillist <maillist@tnss.com>)
Список 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 по дате отправления:

Предыдущее
От: maillist
Дата:
Сообщение: fyi error follow up
Следующее
От: maillist
Дата:
Сообщение: Re: fyi error follow up