Re: BUG #2239: "vacuumdb -a" remove freeze - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2239: "vacuumdb -a" remove freeze
Date
Msg-id 6936.1139324981@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #2239: "vacuumdb -a" remove freeze  (Olleg Samoylov <olleg@mipt.ru>)
List pgsql-bugs
Olleg Samoylov <olleg@mipt.ru> writes:
> IMHO "vacuumdb -a" must don't vacuum database with
> datvacuumxid=datfrozenxid.

That's not going to work because it will fail to detect whether the
database has been modified since the VACUUM FREEZE command.

In any case, what's the point?  As long as you have a routine vacuuming
process in place, it doesn't really matter whether template1 gets
scanned.  The only reason VACUUM FREEZE exists at all is to make it
possible to have a non-connectable, non-vacuumable template0.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "KF Tai"
Date:
Subject: BUG #2244: silent installation to set password never expires
Next
From: Alfranio Correia Junior
Date:
Subject: vacuum segmentation fault