From: | "MG" <pgsql-general(at)carladata(dot)de> |
---|---|
To: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: WARNING: some databases have not been vacuumed in 1953945422 transactions |
Date: | 2007-02-21 12:14:17 |
Message-ID: | 001701c755b1$cf84aea0$340aa8c0@geisslinger |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)adv(dot)magwien(dot)gv(dot)at>
To: "MG *EXTERN*" <pgsql-general(at)carladata(dot)de>
Cc: <pgsql-general(at)postgresql(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-02-21 12:27:11 | Re: WARNING: some databases have not been vacuumed in 1953945422 transactions |
Previous Message | Richard Huxton | 2007-02-21 12:04:17 | Re: REVOKE ALL |