[rossmohax]

Another alternative is ULID, which can be stored as UUID on a Postgres side, but is more b-tree friendly.

[pm90]

Are there articles/examples on how to use ULIDs in postgres?

[rossmohax]

ULID and UUID are same size, passing ULID as UUID to PostgreSQL works seamlessly.