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

From: Richard Huxton <dev(at)archonet(dot)com>
To: MG <pgsql-general(at)carladata(dot)de>
Cc: Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at>, pgsql-general(at)postgresql(dot)org
Subject: Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Date: 2007-02-21 12:27:11
Message-ID: 45DC3A9F.2080105@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Legault 2007-02-21 12:33:01 Re: REVOKE ALL
Previous Message MG 2007-02-21 12:14:17 Re: WARNING: some databases have not been vacuumed in 1953945422 transactions