Horton

Re: UUID or auto-increment

Adam Brusselback <adambrusselback@gmail.com>

View thread View on postgr.es
From: Adam Brusselback <adambrusselback@gmail.com>
To: Israel Brewster <ijbrewster@alaska.edu>
Cc: Stephen Frost <sfrost@snowman.net>, Ron <ronljohnsonjr@gmail.com>, pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2020-08-10T17:38:02Z
Lists: 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