Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Unconventional ways to index UUIDs in PostgreSQL | Citus Con: An Event for Postgres 2023

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
3.6K views 2 years ago #PostgreSQL #Database #CitusCon
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,   / cituscon   #CitusCon #PostgreSQL #Database ...more
...more
Unconventional ways to index UUIDs in PostgreSQL | Citus Con: An Event for Postgres 2023
141Likes
3,606Views
2023Apr 18
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,   / cituscon   #CitusCon #PostgreSQL #Database

Follow along using the transcript.

Microsoft Developer

588K subscribers