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)