corpus.blog
41554 blogs · 4,417,066 posts Claim your blog
Record · corpus.blog/posts/01a08729-4fc4-70e4-87d8-6f7d685bde71

Avoid UUID Version 4 Primary Keys (for Postgres)

jhas78asd · published 2 July 2025

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at andyatkinson.com Wayback capture
0blogs citing
First cited
—
Most recent
—
Rank this month
not ranked
Links from this post
24
Words captured
3,201

Cited by

No blog we hold has cited this post yet.

Links from this post

Link
Host
https://www.cybertec-postgresql.com/en/unexpected-downsides-of-uuid-keys-in-postgresql/
cybertec-postgresql.com
https://github.com/andyatkinson/pg_scripts/pull/20
github.com
https://www.pgmustard.com/blog/work-mem
pgmustard.com
https://github.com/djezzzl/database_consistency/issues/197
github.com
https://pglocks.org/?pgcommand=CLUSTER
pglocks.org
https://dev.to/aws-heroes/uuid-in-postgresql-3n53
dev.to
https://brandur.org/nanoglyphs/026-ids
brandur.org
https://pganalyze.com/blog/5mins-postgres-uuid-vs-serial-primary-keys
pganalyze.com
https://news.ycombinator.com/item?id=46272487
news.ycombinator.com
https://en.wikipedia.org/wiki/Universally_unique_identifier
en.wikipedia.org
https://www.bigbinary.com/blog/rails-6-adds-implicit_order_column
bigbinary.com
https://pgxn.org/dist/sequential_uuids
pgxn.org
https://datatracker.ietf.org/doc/html/rfc4122
datatracker.ietf.org
https://www.postgresql.org/docs/current/functions-uuid.html
postgresql.org
https://stackoverflow.com/a/6953207/126688
stackoverflow.com
https://www.thenile.dev/blog/uuidv7
thenile.dev
https://news.ycombinator.com/item?id=36429986
news.ycombinator.com
https://andyatkinson.com/generating-short-alphanumeric-public-id-postgres
andyatkinson.com
https://planetscale.com/blog/the-problem-with-using-a-uuid-primary-key-in-mysql
planetscale.com
https://pganalyze.com/blog/5mins-postgres-io-basics
pganalyze.com
https://stringintech.github.io/blog/p/postgresql-buffer-cache-a-practical-guide/
stringintech.github.io
https://www.postgresql.org/docs/current/pgbuffercache.html
postgresql.org
https://www.postgresql.org/docs/current/pgprewarm.html
postgresql.org
https://www.cybertec-postgresql.com/en/uuid-serial-or-identity-columns-for-postgresql-auto-generated-primary-keys/
cybertec-postgresql.com