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 BTree 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 BTree 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/citusconplaylist'>https://aka.ms/citusconplaylist
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