Re: Sequential UUID Generation

On 11/19/18 2:08 PM, Uday Bhaskar V wrote:
> I tried below function as which can be used as default to column. But
> every time we need to created 2 sequences, 1st one takes care of the
> first 8 bytes and 2nd takes care of the 2nd part of the UUID. I have not
> tested index and space utilization. I have to examine this. This might
> not be completely unique in the nature. but still trying for the best.
>

I got a bit bored a couple of days ago, so I wrote an extension
generating UUIDs based on either a sequence or timestamp. See

https://blog.2ndquadrant.com/sequential-uuid-generators/

for an explanation and some simple test results.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services