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

Chris


Thu, 11 Apr 2002 09:38:23 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Odd error during vacuum
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



Thu, 11 Apr 2002 11:45:04 +1000 (EST)
Gavin Sherry <swm@linuxworld.com.au>
Re: Odd error during vacuum
Gavin Sherry <swm@linuxworld.com.au> writes:
>> NOTICE:  RegisterSharedInvalid: SI buffer overflow
>> NOTICE:  InvalidateSharedInvalid: cache state reset

> To fix this increase shared_buffers.

AFAIK shared_buffers has no direct effect on the rate of SI overruns.
I suppose it might have an indirect effect just by improving overall
performance...

			regards, tom lane

Wed, 10 Apr 2002 21:57:16 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Odd error during vacuum 