| From: | "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | autovacuum is stopping automatically.... |
| Date: | 2007-12-06 08:26:36 |
| Message-ID: | 83822361-70a5-4f37-8117-297fcac4478f@i12g2000prf.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Curtolo | 2007-12-06 08:42:19 | Import LDAP data to a Postgres database |
| Previous Message | Chris Velevitch | 2007-12-06 07:44:36 | Understanding how partial indexes work? |