Re: Data loss, vacuum, transaction wrap-around

"Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
> I hope this question isn't too stupid....

> Is it be possible to create a "vacuum wraparound" or "vacuum xidreset"
> command which would do the work required to fix the wraparound problem,
> without being as expensive as a normal vacuum of an entire database?

I don't think it'd be worth the trouble. You could skip index cleanup
if you didn't actually delete any tuples, but you'd still have to do all
of the scanning work. The cases where people think they don't need to
do vacuum (because the table didn't have any deleted tuples) wouldn't
get any cheaper at all.

regards, tom lane