VACUUM notices

Started by Ryan Mahoneyalmost 25 years ago3 messagesgeneral
Jump to latest
#1Ryan Mahoney
ryan@paymentalliance.net

VACUUM ANALYZE;
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
VACUUM

What does this mean?

TIA!
-Ryan

#2Gregory Wood
gregw@com-stock.com
In reply to: Ryan Mahoney (#1)
Re: VACUUM notices

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

#3Bruce Momjian
bruce@momjian.us
In reply to: Gregory Wood (#2)
Re: Re: VACUUM notices

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