Dagfinn Ilmari Mannsåker <ilm...@ilmari.org> writes: > Even if a cluster was consuming a million XIDs per second, it would take > over half a million years to wrap around the 64bit range. Is that really > something we should worry about? > > ilmari@[local]:5432 ~=# select 2::numeric^64/10^9/3600/24/365;
Oops, that should be 10^6, not 10^9. I was dithering over whether to do it as a million or a billion per second. For a billion XIDs per second it would last a mere half millennium. > ┌──────────────────┐ > │ ?column? │ > ├──────────────────┤ > │ 584942.417355072 │ > └──────────────────┘ > > - ilmari