Tuesday, February 05, 2019

Max Transaction ID in Firebird



Firebird 3.0.x introduced 48-bit internal transaction IDs that are publicly (via API and MON$ tables) represented as 64-bit numbers. This makes the new limit roughly equal to 2.8*10^14 transactions, later it could be extended up to the 2^63 limit.


Related notice in Firebird 3.0.x release notes.
Related article about Posgtresql : How long will a 64 bit Transaction-ID last in PostgreSQL?

No comments: