Tom Lane wrote:
> "Olleg Samoylov" <olleg_s(at)mail(dot)ru> writes:
>> Opps, template1 must not be vacuumed.
> Says who?
> If we didn't vacuum template1 then it would be subject to XID
> wraparound problems, unless it had never been modified, which is
> something vacuumdb can't count on.
template1 frozen by "vacuum freeze", thus can't be subject of XID
wraparound problems, isn't it?
> If this is done when there are no other open transactions in the same
> database, then it is guaranteed that all tuples in the
> database are ‘‘frozen’’ and will not be subject to transaction
> ID wraparound problems, no matter how long the database is left
IMHO "vacuumdb -a" must don't vacuum database with
In response to
pgsql-bugs by date
|Next:||From: KF Tai||Date: 2006-02-07 08:19:39|
|Subject: BUG #2244: silent installation to set password never expires|
|Previous:||From: Matej Rizman||Date: 2006-02-07 02:41:03|
|Subject: BUG #2243: Postgresql fails to finish some queries|