Thread: VACUUM notices

VACUUM notices

From
ryan@paymentalliance.net
Date:
VACUUM ANALYZE;
NOTICE:  RegisterSharedInvalid: SI buffer overflow
NOTICE:  InvalidateSharedInvalid: cache state reset
VACUUM

What does this mean?


TIA!
-Ryan

Re: VACUUM notices

From
"Gregory Wood"
Date:
> VACUUM ANALYZE;
> NOTICE:  RegisterSharedInvalid: SI buffer overflow
> NOTICE:  InvalidateSharedInvalid: cache state reset
> VACUUM
>
> What does this mean?

I'm too lazy to quote directly, but I believe Tom Lane said they can safely
be ignored and should have been changed from NOTICE: to DEBUG: status.

Greg


Re: Re: VACUUM notices

From
Bruce Momjian
Date:
Yes, and 7.2 will fix this.

[ Charset ISO-8859-1 unsupported, converting... ]
> > VACUUM ANALYZE;
> > NOTICE:  RegisterSharedInvalid: SI buffer overflow
> > NOTICE:  InvalidateSharedInvalid: cache state reset
> > VACUUM
> >
> > What does this mean?
>
> I'm too lazy to quote directly, but I believe Tom Lane said they can safely
> be ignored and should have been changed from NOTICE: to DEBUG: status.
>
> Greg
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026