Re: How to avoid transaction ID wrap - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to avoid transaction ID wrap
Date
Msg-id 28467.1149782950@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to avoid transaction ID wrap  (Hannu Krosing <hannu@skype.net>)
Responses Re: How to avoid transaction ID wrap  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work
Next
From: Alvaro Herrera
Date:
Subject: Re: Type of bare text strings