We have migrated our Database from Oracle to Postgresql there because of replication we went for UUIDs. I have C function ready, will try. Thanks, Uday
On Mon, Oct 29, 2018 at 7:58 PM Merlin Moncure <mmonc...@gmail.com> wrote: > On Mon, Oct 29, 2018 at 9:18 AM Uday Bhaskar V > <uday.bhaskar...@gmail.com> wrote: > > > > Hi, > > > > I have searched in many postgres blogs for Sequential UUID generation, > which can avoid Fragmentation issue. > > > > 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 have > created C function which can generate a sequential UUID, but I am not sure > how best I can use that in postgres. > > > > I would really like to contribute to Postgres, If I can. Please let me > know your thoughts or plans regarding UUID generation. > > I think the right approach here is to build a custom extension. There > are lots of examples of extensions within contrib and on pgxn. > https://pgxn.org/ I guess there might be some utility for this type > as UUID fragmetnation is a major problem (it's one of the reasons I > discourage the use off UUID type indexes). > > merlin >