Re: Disappearing Records

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Disappearing Records
Дата
Msg-id 5445.1130942798@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Disappearing Records  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: Disappearing Records  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> The really nasty thing about it is that because the records are now
> considered really old, as soon as you do run VACUUM it'll start
> removing the rows you want to save...

You sure about that?  I think VACUUM just tests for "committed or not".

I'm too lazy to set up a test case, but it's possible that VACUUM FREEZE
would resurrect wrapped-around tuples, or could be made to with only a
small code tweak.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Hugo
Дата:
Сообщение: Postgres + CentOS
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Disappearing Records