Re: WARNING: some databases have not been vacuumed in 1953945422 transactions

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