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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "MG" <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-15 15:57:39
Message-ID: 25763.1171555059@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"MG" <pgsql-general(at)carladata(dot)de> writes:
> Each night a shell script is being executed.

> vacuumdb --analyze -U cmduser db1
> vacuumdb --analyze -U cmduser db2

You need to hit template1 every so often, too. You probably might
as well just do that every night; it won't take long.

> The last weeks the following warnings are given out:
> WARNING: some databases have not been vacuumed in 1953945422 =
> transactions

> Is this critical?

Yes.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Demian Lessa 2007-02-15 16:15:20 Constraint enforcement
Previous Message John D. Burger 2007-02-15 15:53:48 Re: Recover anything from dropped database?