Backend
Nikolay Samokhvalov: UUIDv4 vs UUIDv7: what a random primary key costs in Postgres
Planet PostgreSQL0 views
Same table, same insert stream, three primary keys on Postgres 18. At 100M rows, UUIDv4 inserted at 0.62 to 0.69 of the rate of an ordered key on the same server, and wrote 1.5 to 1.9 times the WAL per row. Where the cost starts, and what it is made of.
Source:https://postgr.es/p/9B8PreviousIs your SIEM ready for the AI era? Essential insights and preparationsNextNew instrument at Brazil's Sirius accelerator enables researchers to observe solar cells in operation
Related posts
Claude Agent SDK vs rolling your own tool loop: which one for your product?
0dev.to AI
CallBook: a prediction you can't take back, remembered in Walrus and proven through Tatum
0dev.to AI
How to Write Twice as Fast With Voice Typing and AI
0dev.to AI
Pocket died, so I built a library my AI agents can read: introducing Keepfor.me
0dev.to AI
Replaying 147 Claude Code & Codex Sessions to Tune autoCompactWindow (and Catching a 3x Token Overcount)
0dev.to AI
Stripe Subscriptions, CLI First: How I Learned Billing Before Writing a Line of Code
0dev.to WebDev