| 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> |
| Subject: | Re: WARNING: some databases have not been vacuumed in 1953945422 transactions |
| Date: | 2007-02-21 14:09:12 |
| Message-ID: | AFCCBB403D7E7A4581E48F20AF3E5DB2014FB670@EXADV1.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
MG wrote:
>> 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.
>
> 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
What do you mean by (12) age - (4)?
I told you to select datfrozenxid and not age(datfrozenxid).
Try and vacuum ALL databases.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-02-21 14:24:13 | Re: REVOKE ALL |
| Previous Message | Jan de Visser | 2007-02-21 13:54:30 | Re: postgresql vs mysql |