Re: looking for a globally unique row ID

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
Cc: Rafal Pietrak <rafal(at)ztk-rp(dot)eu>, pgsql-general(at)postgresql(dot)org
Subject: Re: looking for a globally unique row ID
Date: 2017-09-15 12:55:52
Message-ID: 20170915125552.GQ20078@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >
> Hmm...
>
> 2 4 6 8 10
>
> 3 6
>
> 5 10
>
> Adding a prime as an increment is not sufficient to guarantee uniqueness!
>
> You have to ensure that the product of the 2 smallest primes you use
> is greater than any number you'd need to generate.  With such large
> primes you may run out of sequence numbers faster than you would
> like!
>
>
> Cheers,
> Gavin

Yes, you are right. That would not help.

Regards,
Ken

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2017-09-15 13:04:36 Re: looking for a globally unique row ID
Previous Message Justin Pryzby 2017-09-15 11:57:49 Re: "Canceling authentication due to timeout" with idle transaction and reindex