Hello Tom,
thanks for your answer.
But I don't understand why there are changes of the databases template1 and
template0 at all?
I thought they are only templates.
Regards
Michaela
----- Original Message -----
From: "Tom Lane" <tgl@xxxxxxxxxxxxx>
To: "MG" <pgsql-general@xxxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, February 15, 2007 4:57 PM
Subject: Re: [GENERAL] WARNING: some databases have not been vacuumed in
1953945422 transactions
"MG" <pgsql-general@xxxxxxxxxxxx> 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
