UUID vs Bigint Battle!!! | Scaling Postgres 302

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

In this episode of Scaling Postgres, we discuss when and how you should use UUIDs or not, how to optimize space with column order and arrays, whether it is better to tune parameters or queries and what devs should know about Postgres with Andrew Atkinson.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Postgres Performance Demystified Webinar
00:34 - UUID Benchmark War
03:22 - UUID in Postgres: PgSQLPhriday #015
04:16 - PGSQL Phriday #015: Primary keys: UUID, CUID, or TSID?
05:02 - Postgres.AI bot interview for PGSQL Phriday #015
05:36 - Reducing table size with optimal column ordering and array-based storage
06:59 - Tuning Parameters vs Tuning Queries: presentation and recording
07:48 - What Developers Should Know About Postgres With Andrew Atkinson | Rubber Duck Dev Show 114
08:25 - Modern SQL
09:24 - Postgres again elected DBMS of the Year in 2023, but I'm worried
10:20 - PostgreSQL is Enough Gist
11:11 - Podcast highlights on benchmarking Postgres performance, from Path To Citus Con Episode 11
11:26 - Benchmarking Postgres Vector Search approaches: Pgvector vs Lantern
12:00 - Pgvector vs Lantern part 2 - The one with parallel indexes
12:16 - Contemplating Decentralized Extension Publishing
12:54 - Outro

#postgres #postgresql