Re: autovacuum is stopping automatically....

On 12月6日, 下午1014分, alvhe(dot)(dot)(dot)(at)alvh(dot)no-ip(dot)org (Alvaro Herrera) wrote:
> 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)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majord(dot)(dot)(dot)(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

SELECT datname, age(datfrozenxid) FROM pg_database
i got 1670750918 in template0, and 1108786817 in mydatabase.
is't normal?