Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: MG <pgsql-general@xxxxxxxxxxxx>
Subject: Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
From: Richard Huxton <dev@xxxxxxxxxxxx>
Date: Wed, 21 Feb 2007 12:27:11 +0000
Cc: Albe Laurenz <all@xxxxxxxxxxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <001701c755b1$cf84aea0$340aa8c0@geisslinger>
References: <001201c750d9$60016d20$340aa8c0@geisslinger> <25763.1171555059@xxxxxxxxxxxxx> <001201c751a0$6949a600$340aa8c0@geisslinger> <AFCCBB403D7E7A4581E48F20AF3E5DB2013F2A1F@xxxxxxxxxxxxxxxxxxxxxxxxx> <001701c755b1$cf84aea0$340aa8c0@geisslinger>
User-agent: IceDove 1.5.0.9 (X11/20061220)

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 haveoccurred ACROSS ALL DATABASES since the "datfrozenxid" in that database.


--
  Richard Huxton
  Archonet Ltd

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- WARNING: some databases have not been vacuumed in 1953945422 transactions
  - From: MG
- Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
  - From: Tom Lane
- Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
  - From: MG
- Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
  - From: Albe Laurenz
- Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
  - From: MG

Prev by Date: Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Next by Date: Re: REVOKE ALL
Previous by thread: Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Next by thread: Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux