Jawlon·Oct 27Why Your Inserts Slow Down as the Table Grows, and How to Fix ItYour UUID primary key works fine today. Until the table grows. In my test, at 10 million rows, inserts got 14x slower. The fix was another…
Nazmul Hasan·Oct 262.3x Slower Inserts With UUIDv4: Postgres 18’s UUIDv7 Ties bigint, With One COPY Trap6M rows, a key index up to 3.7x shared_buffers, 16 writers. Which key a new table should use, and where to generate it.
Alonso Del Arte·Oct 16Bit masking operations for UUIDsThere are eight officially recognized versions of universally unique identifiers (UUIDs), and three officially recognized variants. The…
Eugene Novikov·Oct 11PostgreSQL: UUIDv4 vs UUIDv7About a year ago, PostgreSQL 18 delivered native support for UUIDv7. In the article below, I’m gonna deep dive into the impact of UUIDv4 in…A response icon1A response icon1
Kingdesign·Sep 28Should You Use UUIDs as Database Primary Keys?This is one of the longest running debates in database design. Auto increment integers are small and fast. UUIDs are globally unique and…A response icon1A response icon1
Dhana Sekaran Chellamuthu·Sep 27How to Choose the Right Primary ID for Your DatabaseIntroduction- Hidden cost of primary keys
Kingdesign·Sep 24All UUID Versions Explained: v1 to v8Every UUID carries a version number in the first digit of its third group. That single hex character tells you what algorithm produced the…
Tasfia Zaima·Sep 24UUIDs Aren’t Exactly Guessable… So How Do You Find IDORs?When testing APIs, you may encounter endpoints such as:
Kingdesign·Sep 23UUID v4 vs v7: Which One Should You Use?For fifteen years the answer to “which UUID should I use” was simply version 4. It is random, it is everywhere, and every language can make…
