29:52Unconventional ways to index UUIDs in PostgreSQL | Citus Con: An Event for Postgres 2023
From the creator
Video of a conference talk by Haki Benita about unconventional ways to index UUIDs in PostgreSQL, delivered at Citus Con: An Event for Postgres 2023. You probably have at least one or two UUIDs in your schema with a good old B-Tree index. But, have you ever considered that PostgreSQL may have other options for you? Haki Benita is a tech lead specializing in databases, web development, and performance tuning. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 02:13 What are UUIDs good for? ⏩ 05:22 Sortable UUIDs, specifically ULIDs ⏩ 08:19 Indexing UUIDs in PostgreSQL ⏩ 11:08 B-Tree is the king of all Postgres indexes ⏩ 17:37 Hash indexes, the ugly duckling of index types ⏩ 21:12 Using block range indexes (BRIN) ⏩ 26:34 BRIN Index and Bloom filters ✅ Learn more: Watch more Citus Con 2023 talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect: Twitter – @CitusCon, https://twitter.com/CitusCon #CitusCon #PostgreSQL #Database
Published 2023-04-18 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.
Keep exploring Learn to Code
29:52
04:07
11:04"Anti-Slop" Designs with Impeccable (a Crash Course) #5 - Enable Image Generation
Net Ninja
2:25:40
42:55Java Graphics Programming Tutorial - How To Draw Shapes, Paths, Curves, and Apply Transformations
choobtorials
08:10
18:31