pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
NOTICE: Vacuum: can not process indices, views and certain system tables
2+ messages / 2 participants
[nested] [flat]

* NOTICE: Vacuum: can not process indices, views and certain system tables
@ 2002-02-01 20:25 Diehl, Jeffrey <jdiehl@sandia.gov>
  2002-02-01 21:19 ` Re: NOTICE: Vacuum: can not process indices, views and certain system tables Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Diehl, Jeffrey @ 2002-02-01 20:25 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: NOTICE: Vacuum: can not process indices, views and certain system tables
  2002-02-01 20:25 NOTICE: Vacuum: can not process indices, views and certain system tables Diehl, Jeffrey <jdiehl@sandia.gov>
@ 2002-02-01 21:19 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2002-02-01 21:19 UTC (permalink / raw)
  To: Diehl, Jeffrey <jdiehl@sandia.gov>; +Cc: pgsql-sql

"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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-02-01 21:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-02-01 20:25 NOTICE: Vacuum: can not process indices, views and certain system tables Diehl, Jeffrey <jdiehl@sandia.gov>
2002-02-01 21:19 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox