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: aka.ms/cituscon-playlist
📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: aka.ms/cituscon
📌 Let’s connect:
Twitter - @CitusCon, / cituscon
#CitusCon #PostgreSQL #Database
Негізгі бет Ғылым және технология Unconventional ways to index UUIDs in PostgreSQL | Citus Con: An Event for Postgres 2023
Пікірлер: 2