Re: Vacuum Complains

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum Complains
Дата
Msg-id 4851.959573768@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuum Complains  (Fabrice Scemama <fabrice@scemama.org>)
Список pgsql-general
Fabrice Scemama <fabrice@scemama.org> writes:
> when running a daily vacuum, my cron regularly reports this
> message from Pg (7.0 RC1 / RH5.2 with glibc2.1 / compiled
> with gcc 2.5.2):

> NOTICE:  RegisterSharedInvalid: SI buffer overflow
> NOTICE:  InvalidateSharedInvalid: cache state reset

> Does anyone know what it means exactly ?

It's not anything to worry about --- those are just for debugging
purposes.  I'd expect those to show up if you have other backends
that are hung up in transactions waiting for the vacuum to finish.
Or maybe even without any other backends, if you have large system
catalogs...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Re: Another problem - exporting from access
Следующее
От: Tom Lane
Дата:
Сообщение: Re: group by week (ww), plus -S performance