Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
От | MG |
---|---|
Тема | Re: WARNING: some databases have not been vacuumed in 1953945422 transactions |
Дата | |
Msg-id | 001701c755b1$cf84aea0$340aa8c0@geisslinger обсуждение исходный текст |
Ответ на | WARNING: some databases have not been vacuumed in 1953945422 transactions ("MG" <pgsql-general@carladata.de>) |
Ответы |
Re: WARNING: some databases have not been vacuumed in 1953945422
transactions
|
Список | pgsql-general |
Yes there are changes. db1, db2 and template1 has been vacuumed over night, not template0. 20.02.07 datname - (12) age - (4) 1 db1 1.075.878.187 2 db2 1.075.847.556 3 template1 1.976.569.889 4 template0 1.976.569.889 21.02.07 datname - (12) age - (4) 1 db1 1.074.758.205 2 db2 1.074.728.832 3 template1 1.074.728.720 4 template0 1.978.965.587 Regards Michaela ----- Original Message ----- From: "Albe Laurenz" <all@adv.magwien.gv.at> To: "MG *EXTERN*" <pgsql-general@carladata.de> Cc: <pgsql-general@postgresql.org> Sent: Monday, February 19, 2007 9:41 AM Subject: Re: [GENERAL] WARNING: some databases have not been vacuumed in 1953945422 transactions > But I don't understand why there are changes of the databases > template1 and > template0 at all? > I thought they are only templates. I don't think that there were any changes to the template databases. You detected a difference in age(datfrozenxid) - try selecting datfrozenxid itself and you will probably see that it does not change over time. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
В списке pgsql-general по дате отправления: