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?
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.
Thanks a lot.