Fun With UUIDs | POSETTE: An Event for Postgres 2025

From the creator

Video of a conference talk discussing why UUIDs have a bad reputation, mostly based on randomly allocated UUIDs effect on indexes. But UUIDs also give us 16 bytes of space to play with, which can be to our advantage. We can use the space of UUIDs to structure and encode data into our identifiers. This can be really useful for multi-tenant applications, or for sharding or partitioning. UUIDs can also help improve your web app security by not leaking sequentially allocated ids. We'll take a look at index performance concerns with randomly allocated UUIDs, sequential IDs and sensibly structured UUIDs. Seeing how we can go about extracting information from these UUIDs and how to build these UUIDs inside PostgreSQL, and how we can look at the performance of these functions. And finally, looking at adding support for bitwise operations on UUIDs using an extension. Chris Ellis is a computing and electronics geek, who loves working with open source software. He is a jack of all trades consultant usually spending his time engineering systems with PostgreSQL, Java and Linux. Now and then he gets time to design some electronics, often involving ESP32s, Raspberry Pi CM4s and LED badges. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:14 What Are UUIDs – Definition & Structure ⏩ 03:43 Problems with UUIDs ⏩ 09:02 Why Use UUIDs ⏩ 11:54 Encoding Additional Information in UUIDs ⏩ 14:14 Best of Both Worlds with UUIDv7 ⏩ 22:32 Partitioning with UUIDs 📕 Everything you nee

Published 2025-06-12 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.