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

  • Options
    Bryan_HBryan_H Vertica Employee 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