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?
Question
Transaction ID cyclic or noncyclic
+1
+2It'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.
+1Thanks a lot.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
