Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd error during vacuum - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Odd error during vacuum
Date
Msg-id 25035.1018490236@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd error during vacuum  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: help with bison
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: help with bison