Re:Index bloat reduced in PostgreSQL v14
by ruuda on Saturday September 11, 2021 @05:39AM
(#28490639)
Transaction id wraparound. Transaction ids are 32 bit and they are used in a ring like manner, so a transaction id can only be reused if there are no open transactions before it. If you (accidentally) keep a transaction open for a long time, then after a while you run out of transaction ids, and it is tough to recover from, because management operations themselves involve creating transactions.
[ Parent
| on HN ]
There are no comments on this comment yet.