Fujitsu PostgreSQL blog

How to fix transaction wraparound in PostgreSQL?

Written by Nishchay Kothari | July 13, 2023

As a PostgreSQL DBA, we commonly hear and use the term "dead rows" and "bloat." In this blog post, I'd like to talk about these concepts as well as "transaction wraparound," one of the most dangerous situations in PostgreSQL. I'll also outline how to handle this problem with an example.