Re: pg_shdepend vacuum.

I'm experiencing the same thing with 9.0.4 running on win server 2003. Reams
of messages like this... (I've changed the database names in the following
log snipit)

2013-11-22 09:37:42 CST ERROR: canceling autovacuum task
2013-11-22 09:37:42 CST CONTEXT: automatic vacuum of table
"x1.pg_catalog.pg_shdepend"
2013-11-22 09:37:42 CST ERROR: canceling autovacuum task
2013-11-22 09:37:42 CST CONTEXT: automatic vacuum of table
"x2.pg_catalog.pg_shdepend"
2013-11-22 09:37:43 CST ERROR: canceling autovacuum task
2013-11-22 09:37:43 CST CONTEXT: automatic vacuum of table
"x3.pg_catalog.pg_shdepend"
2013-11-22 09:37:44 CST ERROR: canceling autovacuum task
2013-11-22 09:37:44 CST CONTEXT: automatic vacuum of table
"x4.pg_catalog.pg_shdepend"
2013-11-22 09:37:45 CST ERROR: canceling autovacuum task
2013-11-22 09:37:45 CST CONTEXT: automatic vacuum of table
"x5.pg_catalog.pg_shdepend"
2013-11-22 09:37:45 CST ERROR: canceling autovacuum task
2013-11-22 09:37:45 CST CONTEXT: automatic vacuum of table
"x6.pg_catalog.pg_shdepend"
2013-11-22 09:37:46 CST ERROR: canceling autovacuum task
2013-11-22 09:37:46 CST CONTEXT: automatic vacuum of table
"x7.pg_catalog.pg_shdepend"
2013-11-22 09:37:47 CST ERROR: canceling autovacuum task
2013-11-22 09:37:47 CST CONTEXT: automatic vacuum of table
"x8.pg_catalog.pg_shdepend"
2013-11-22 09:37:48 CST ERROR: canceling autovacuum task
2013-11-22 09:37:48 CST CONTEXT: automatic vacuum of table
"x9.pg_catalog.pg_shdepend"
2013-11-22 09:37:48 CST ERROR: canceling autovacuum task
2013-11-22 09:37:48 CST CONTEXT: automatic vacuum of table
"x10.pg_catalog.pg_shdepend"
2013-11-22 09:37:49 CST ERROR: canceling autovacuum task
2013-11-22 09:37:49 CST CONTEXT: automatic vacuum of table
"x11.pg_catalog.pg_shdepend"
2013-11-22 09:37:50 CST ERROR: canceling autovacuum task
2013-11-22 09:37:50 CST CONTEXT: automatic vacuum of table
"x12.pg_catalog.pg_shdepend"
2013-11-22 09:37:51 CST ERROR: canceling autovacuum task
2013-11-22 09:37:51 CST CONTEXT: automatic vacuum of table
"x13.pg_catalog.pg_shdepend"
2013-11-22 09:37:52 CST ERROR: canceling autovacuum task
2013-11-22 09:37:52 CST CONTEXT: automatic vacuum of table
"x15.pg_catalog.pg_shdepend"
2013-11-22 09:37:52 CST ERROR: canceling autovacuum task
2013-11-22 09:37:52 CST CONTEXT: automatic vacuum of table
"x14.pg_catalog.pg_shdepend"
2013-11-22 09:37:53 CST ERROR: canceling autovacuum task

The messages travel across ALL the databases that we have but only seem to
involve the pg_shdepend table.

They even involve the template databases, and databases that have virtually
no activity.

2013-11-22 09:38:03 CST CONTEXT: automatic vacuum of table
"template0.pg_catalog.pg_shdepend"

2013-11-22 08:25:14 CST CONTEXT: automatic analyze of table
"template1.pg_catalog.pg_shdepend"

The errors repeat approximately every minute.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-shdepend-vacuum-tp5744209p5779785.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.