Sequential UUID Generation

From: Uday Bhaskar V <uday(dot)bhaskar579(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Sequential UUID Generation
Date: 2018-10-29 15:06:25
Message-ID: CAFowjW2LG+eoezyrKW7k1Tvy7_VKTemkk5ErasBe6-dS0DBL1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 generates sequential UUID. I need similar
functionality here.
I want to create a function which generates a sequential UUIDs, Any
suggestions or support would be much appreciated.

Thanks,
Uday

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gierth 2018-10-29 15:17:28 Re: FETCH FIRST clause WITH TIES option
Previous Message Antonin Houska 2018-10-29 14:10:10 Re: shared-memory based stats collector