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
completel
. And it would also be fairly random, making
> it difficult to guess UUIDs.
>
> regards
>
> On 10/29/2018 04:06 PM, Uday Bhaskar V wrote:
> > Hi,
> >
> > We have migrated from Oracle to Postgres, there because of the
> > replication requirements we used UUI
Hi,
We have migrated from Oracle to Postgres, there because of the replication
requirements we used UUID columns.
I did a POC(in postgres) with sequential UUID against Non sequential which
has shown lot of different in space utilization and index size. Sql server
has "newsequentialid" which gener
