Обсуждение: NOTICE: Vacuum: can not process indices, views and certain system tables

Поиск
Список
Период
Сортировка

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

От
"Diehl, Jeffrey"
Дата:
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



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

От
Tom Lane
Дата:
"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