Indexes on UUID - Fragmentation Issue - Mailing list pgsql-performance

From Uday Bhaskar V
Subject Indexes on UUID - Fragmentation Issue
Date
Msg-id CAFowjW1J7KMjPfQY0ST94V0t=rcjz13HkjMuqJVP_Lk6Zn8Cag@mail.gmail.com
Whole thread Raw
Responses Re: Indexes on UUID - Fragmentation Issue  (Merlin Moncure <mmoncure@gmail.com>)
Re: Indexes on UUID - Fragmentation Issue  (Andreas Karlsson <andreas@proxel.se>)
List pgsql-performance
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.

Regards,
Uday

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: DELETE / UPDATE from partition not optimized (11.0)
Next
From: Merlin Moncure
Date:
Subject: Re: Indexes on UUID - Fragmentation Issue