Re: autovacuum is stopping automatically....

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: autovacuum is stopping automatically....
Date: 2007-12-06 14:14:30
Message-ID: 20071206141430.GC8451@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Charles.Hou wrote:
> this is the pg_log...
> after 2007-12-04 10:40:37 CST 15533 , it always autovacuum "template0"
> not mydatabase...

Is there an ERROR in the log? My guess is that template0 is in danger
of Xid wraparound and autovacuum wants to process it, but it can't for
some reason.

My second guess is that you are still running a version below 8.1.6, or
were for a nontrivial amount of time. Said versions contain a bug that
can make a future vacuum on template0 error out every time.

--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Es filósofo el que disfruta con los enigmas" (G. Coli)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henrik 2007-12-06 14:18:25 Unreasonable size of table pg 8.2.5
Previous Message Cedric Boudin 2007-12-06 13:53:13 Re: simple update on boolean