Re: UUID or auto-increment - Mailing list pgsql-general

From Adam Brusselback
Subject Re: UUID or auto-increment
Date
Msg-id CAMjNa7cYXN3VUJPb6Pt=0WHgSyTzA0v2bb-rAaT_2Ey8XckYFw@mail.gmail.com
Whole thread Raw
In response to Re: UUID or auto-increment  (Israel Brewster <ijbrewster@alaska.edu>)
List pgsql-general
>  I would point out, however, that using a V1 UUID rather than a V4 can help with this as it is sequential, not random (based on MAC address and timestamp + random)

I wanted to make this point, using sequential UUIDs helped me reduce write amplification quite a bit with my application, I didn't use V1, instead I used: https://pgxn.org/dist/sequential_uuids/

Reduces the pain caused by UUIDs a ton IMO.
-Adam

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: SQL Question about like
Next
From: Michael Nolan
Date:
Subject: Re: SQL Question about like