Re: Indexes on UUID - Fragmentation Issue

On Mon, Oct 29, 2018 at 9:18 AM Uday Bhaskar V
<uday.bhaskar579@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
utilizationand index size. Sql server has "newsequentialid" which generates sequential UUID. I have created C function
whichcan 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