Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Transaction ID cyclic or noncyclic

Would like to know if there is any maximum limit for Transaction Id value in Vertica? Does it recycle after reaching specific limit or period of time?

Best Answer

  • Bryan_HBryan_H Administrator
    Answer ✓

    It's a 64-bit integer (so maximum value is 64-bit signed int limit) that is stored outside the catalog and should not repeat, but we provide no guarantee that you can't get duplicate transaction ID's. It's very unlikely during normal run, but may happen e.g. after restart or upgrade or restore from backup.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.