Re: [GENERAL] looking for a globally unique row ID

Поиск
Список
Период
Сортировка
От Kenneth Marshall
Тема Re: [GENERAL] looking for a globally unique row ID
Дата
Msg-id 20170915125552.GQ20078@aart.rice.edu
обсуждение исходный текст
Ответ на Re: [GENERAL] looking for a globally unique row ID  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список 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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: [GENERAL] "Canceling authentication due to timeout" with idletransaction and reindex
Следующее
От: Rafal Pietrak
Дата:
Сообщение: Re: [GENERAL] looking for a globally unique row ID