On 12月6日, 下午10�r14分, alvhe...@alvh.no-ip.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...@postgresql.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?