Thread: NOTICE: Vacuum: can not process indices, views and certain system tables

NOTICE: Vacuum: can not process indices, views and certain system tables

From
"Diehl, Jeffrey"
Date:
I've been getting this message in my syslog logs.  It's causing BigBrother
to indicate an outage of some type, which in turn, causes by availability
metrics to go down.

So, what does this mean, and how can I get rid of these messages:

NOTICE: Vacuum: can not process indices, views and certain system tables.

Thanx in advance,
Mike Diehl,
Network Monitoring Tool Devl.
Sandia National Laboratories.
(505) 284-3137
jdiehl@sandia.gov



"Diehl, Jeffrey" <jdiehl@sandia.gov> writes:
> So, what does this mean, and how can I get rid of these messages:
> NOTICE: Vacuum: can not process indices, views and certain system tables.

Sounds like you're asking it to VACUUM an index or view (specifically,
by name, ie VACUUM name-of-index-or-view).  Don't do that.
        regards, tom lane