News for hackers. Stuff that matters.

A comment on PostgreSQL's Imperfections. Parent comment

Re:PostgreSQL's Imperfections by rossmohax on Saturday April 04, 2020 @05:43AM (#22777270)
> There seems to be no way to instruct postgres to "clean" those XIDs in any way

There is, VACUUM FREEZE

[ Parent | on HN ]
Re:PostgreSQL's Imperfections by karyon on Saturday April 04, 2020 @05:47AM (#22777293)
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...
[ Parent | on HN ]
Re:PostgreSQL's Imperfections by rossmohax on Saturday April 04, 2020 @04:01PM (#22781039)
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.
[ Parent | on HN ]