Re: Odd error during vacuum

Поиск
Список
Период
Сортировка
От Gavin Sherry
Тема Re: Odd error during vacuum
Дата
Msg-id Pine.LNX.4.21.0204111143280.20663-100000@linuxworld.com.au
обсуждение исходный текст
Ответ на Odd error during vacuum  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Ответы Re: Odd error during vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, 11 Apr 2002, Christopher Kings-Lynne wrote:

> Hi all,
> 
> I got these odd messages while doing a vacuum in 7.1.3 0 - any idea what
> they mean? I assume it's not fatal as they're just notices, but I've never
> had them before and haven't had them since.
> 
> NOTICE:  RegisterSharedInvalid: SI buffer overflow
> NOTICE:  InvalidateSharedInvalid: cache state reset

This just means that the cache invalidation buffer got overloaded and was
reset. Its not really a problem (except in terms of performance). I would
say that if you haven't seen this before your database is getting more
usage and/or more data.

To fix this increase shared_buffers.

Gavin




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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Odd error during vacuum
Следующее
От: Tom Lane
Дата:
Сообщение: Re: help with bison