this is the pg_log...
after 2007-12-04 10:40:37 CST 15533 , it always autovacuum "template0"
not mydatabase...
why?
i didn't change any configuration...
2007-12-04 10:14:55 CST 23858 LOG: autovacuum: processing database
"mydatabase"
2007-12-04 10:23:15 CST 31601 LOG: autovacuum: processing database
"postgres"
2007-12-04 10:23:35 CST 31932 LOG: autovacuum: processing database
"test"
2007-12-04 10:23:55 CST 32234 LOG: autovacuum: processing database
"template1"
2007-12-04 10:24:15 CST 32477 LOG: autovacuum: processing database
"template0"
2007-12-04 10:24:35 CST 365 LOG: autovacuum: processing database
"roller"
2007-12-04 10:24:55 CST 668 LOG: autovacuum: processing database
"mydatabase"
2007-12-04 10:31:29 CST 6858 LOG: autovacuum: processing database
"roller"
2007-12-04 10:32:42 CST 8074 LOG: autovacuum: processing database
"test"
2007-12-04 10:40:37 CST 15533 LOG: autovacuum: processing database
"template0"
2007-12-04 10:41:02 CST 15957 LOG: autovacuum: processing database
"template0"
2007-12-04 10:41:27 CST 16277 LOG: autovacuum: processing database
"template0"
2007-12-04 10:41:52 CST 16710 LOG: autovacuum: processing database
"template0"
2007-12-04 10:42:16 CST 17095 LOG: autovacuum: processing database
"template0"
2007-12-04 10:42:41 CST 17455 LOG: autovacuum: processing database
"template0"
2007-12-04 10:43:06 CST 17848 LOG: autovacuum: processing database
"template0"
2007-12-04 10:43:31 CST 18257 LOG: autovacuum: processing database
"template0"
2007-12-04 10:43:55 CST 18648 LOG: autovacuum: processing database
"template0"
2007-12-04 10:44:20 CST 18966 LOG: autovacuum: processing database
"template0"
2007-12-04 10:44:45 CST 19356 LOG: autovacuum: processing database
"template0"
2007-12-04 10:45:10 CST 19767 LOG: autovacuum: processing database
"template0"
2007-12-04 10:45:34 CST 20140 LOG: autovacuum: processing database
"template0"
2007-12-04 10:45:58 CST 20527 LOG: autovacuum: processing database
"template0"
2007-12-04 10:46:22 CST 20905 LOG: autovacuum: processing database
"template0"
2007-12-04 10:46:46 CST 21316 LOG: autovacuum: processing database
"template0"
2007-12-04 10:47:10 CST 21634 LOG: autovacuum: processing database
"template0"
2007-12-04 10:47:35 CST 21996 LOG: autovacuum: processing database
"template0"
2007-12-04 10:48:00 CST 22399 LOG: autovacuum: processing database
"template0"
2007-12-04 10:48:24 CST 22748 LOG: autovacuum: processing database
"template0"
2007-12-04 10:48:49 CST 23136 LOG: autovacuum: processing database
"template0"
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
