Re: BUG #2239: "vacuumdb -a" remove freeze
От | Olleg Samoylov |
---|---|
Тема | Re: BUG #2239: "vacuumdb -a" remove freeze |
Дата | |
Msg-id | 43E84E0E.5080605@mipt.ru обсуждение исходный текст |
Ответ на | Re: BUG #2239: "vacuumdb -a" remove freeze (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: BUG #2239: "vacuumdb -a" remove freeze
|
Список | pgsql-bugs |
Tom Lane wrote: > "Olleg Samoylov" <olleg_s@mail.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? man vacuum: > 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 > unvacuumed. IMHO "vacuumdb -a" must don't vacuum database with datvacuumxid=datfrozenxid. -- Olleg Samoylov
В списке pgsql-bugs по дате отправления: