Re: Indexes on UUID - Fragmentation Issue

or prepend the UUID with a timestamp? Regards, Michael Vitale Andreas Karlsson Monday, October 29, 2018 10:52 AM On 10/29/2018 02:29 PM, Uday Bhaskar V wrote:> I have How is it implemented? I can personally see two ways of generating sequential UUID:s. Either you us

Re: Indexes on UUID - Fragmentation Issue

On 10/29/2018 02:29 PM, Uday Bhaskar V wrote:> 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.

Re: Indexes on UUID - Fragmentation Issue

On Mon, Oct 29, 2018 at 9:18 AM Uday Bhaskar V 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 uti

Indexes on UUID - Fragmentation Issue

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 generat