UUIDv7 or bigint in PostgreSQL: arrival order matters too
A Docker comparison of bigint, UUIDv4 and UUIDv7: insert time, index size, WAL and arrival order. Includes measured results and runnable code.
Blog / Matteo Vincenti
Notes from work.
I write about AI in everyday work, software development and how teams work together. I start with business problems and explore the technical decisions.
2 articles in Performance
Category: Performance Clear category
EAV in PostgreSQL: correct queries before performance
EAV, relational columns or JSONB for custom fields? A reproducible SQL lab in Docker shows how to avoid false matches before testing performance.
Contact