Re: Is monotonous xid8 is a right way to do?

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