This article posted on SQLServerCentral explains details about PostgreSQL internals which the nerdiest database developers among us may find interesting. It also makes me glad my DBA days are long behind me. 
Enjoy!
1 Like
This is somewhat similar (same?) to the issue coming for busy Polaris environments: Polaris transactions will "run out" of space due to being an "int" data type – Innovate with us