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: > > > >

Indexes on UUID - Fragmentation Issue

2018-10-29 Thread Uday Bhaskar V
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