Re: Indexes on UUID - Fragmentation Issue

2018-10-30 Thread Uday Bhaskar V
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 wrote: > On Mon, Oct 29, 2018 at 9:18 AM Uday Bhaskar V > wrote: > > > > Hi, > > > > I have sear

Re: Indexes on UUID - Fragmentation Issue

2018-10-29 Thread MichaelDBA
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

2018-10-29 Thread Andreas Karlsson
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

2018-10-29 Thread Merlin Moncure
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