5mins of Postgres E59: UUIDs vs Serial for Primary Keys - what's the right choice?
Today, we talk about deciding whether to use UUIDs vs bigints for your primary key.
Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
UUIDs vs serials for keys - by Christophe Pettus
https://thebuild.com/blog/2023/02/16/...
Christophe Pettus on Twitter
/ xof
Identity Crisis: Sequence v. UUID as Primary Key - by Brandur
https://brandur.org/nanoglyphs/026-ids
Brandur on Twitter
/ brandur
Postgres Hackers thread about UUIDv7
https://www.postgresql.org/message-id...
5mins of Postgres E58: Handling integer sequence overflow without downtime in Postgres
https://pganalyze.com/blog/5mins-post...
pganalyze newsletter issue of April 2022 about ULIDs
https://2591017.hs-sites.com/a-6x-wri...
5mins of Postgres E10: max_wal_size, Postgres full page writes and UUID vs BIGINT primary keys
https://pganalyze.com/blog/5mins-post...
Effective indexing in Postgres - eBook
https://pganalyze.com/ebooks/postgres...