On 12月6日, 下午10?14分, alvhe...@xxxxxxxxxxxxxx (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...@xxxxxxxxxxxxxx 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? ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
