Postgres Pro
Downloads
Home   >   mailing lists

Re: WARNING: some databases have not been vacuumed in 1953945422 transactions - Mailing list pgsql-general

From Albe Laurenz
Subject Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB2013F2A1F@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to WARNING: some databases have not been vacuumed in 1953945422 transactions  ("MG" <pgsql-general@carladata.de>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: delete from ... where not in
Next
From: Alban Hertroys
Date:
Subject: Re: Why *exactly* is date_trunc() not immutable ?