Re: Disappearing Records - Mailing list pgsql-general

From Tom Lane
Subject Re: Disappearing Records
Date
Msg-id 5445.1130942798@sss.pgh.pa.us
Whole thread Raw
In response to Re: Disappearing Records  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Disappearing Records
List 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 by date:

Previous
From: Hugo
Date:
Subject: Postgres + CentOS
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Disappearing Records