Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Date
Msg-id 45DC3A9F.2080105@archonet.com
Whole thread Raw
In response to Re: WARNING: some databases have not been vacuumed in 1953945422 transactions  ("MG" <pgsql-general@carladata.de>)
List pgsql-general
Tree view 
MG wrote:
> Yes there are changes.
> db1, db2 and template1 has been vacuumed over night, not template0.

>      4 template0 1.976.569.889

>      4 template0 1.978.965.587

Not necessarily - the age is the count of how many transactions have
occurred ACROSS ALL DATABASES since the "datfrozenxid" in that database.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "MG"
Date:
Subject: Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Next
From: "David Legault"
Date:
Subject: Re: REVOKE ALL