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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
