Dagfinn Ilmari Mannsåker <ilmari@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
