Hacker News new | ask | show | jobs
by rossmohax 2273 days ago
> There seems to be no way to instruct postgres to "clean" those XIDs in any way

There is, VACUUM FREEZE
1 comments
karyon 2273 days ago
Sadly, since 9.4, that does not clear the XID anymore, see that blue box here: https://www.postgresql.org/docs/9.4/routine-vacuuming.html#V...
link
rossmohax 2273 days ago
Thanks, that was news to me. Interestingly replacing XID with frozen one still makes a valid tuple, so it might be just a few lines patch for you to get what you want.
link