Re: How to avoid transaction ID wrap

Hannu Krosing <hannu@skype.net> writes:
> If the aim is to *only* avoid transaction wraparound, then maybe we
> could introduce VACUUM FREEZE ONLY; which never removes any old tuples,
> but instead just marks them by setting xmin=xmax for them, in addition
> to its freezing of live-and-visible-to-all tuples.

> This would avoid touching indexes at all and may well be what is desired
> for tables with only very little updates/deletes.

Seems like useless complexity.  If there are so few dead tuples that you
can afford to not reclaim them, then there are so few that reclaiming
them isn't really going to cost much either ...
        regards, tom lane