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.
3 articles in PostgreSQL
Topic: PostgreSQL Clear topic
Enterprise RAG: why it retrieves the wrong document
A reproducible lab compares full-text, embeddings and hybrid search to show when to fix missing sources, eligibility or ranking.
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