Re: [GENERAL] pg_shdepend vacuum.

2013-11-22 Thread John Cantin
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 CSTERROR: canceling autovacuum task 2013-11-22 09:37:42 CSTCONTEXT: automatic vacuum of table "x1.p

Re: [GENERAL] pg_shdepend vacuum.

2013-02-08 Thread Jeff Janes
On Thu, Feb 7, 2013 at 3:47 AM, Ranjeet Dhumal wrote: > Hi All , > > Am using postgres version 9.0.1 . You should upgrade to the latest minor release. A lot of things have been fixed since 9.0.1, including better logging of autovacuum cancels (in 9.0.9) which will tell you what is causing the ca

[GENERAL] pg_shdepend vacuum.

2013-02-07 Thread Ranjeet Dhumal
Hi All , Am using postgres version 9.0.1 . In daily postgres log am getting same kind of log for many time , is it because of more table creation and deletion is going on and its trying to vaccum pg_shdepend ? But its getting canceled every time , why is it so ? 2013-02-05 00:00:09 CST [25319]: [