The Worst Part, Pluggable Storage, A Busy System, Data Architecture | Scaling Postgres 264
Vložit
- čas přidán 4. 07. 2024
- To get the show notes as well as get notified of new episodes, visit:
www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss the worst part of Postgres, the status of pluggable storage, what makes a busy system and methods for managing different data architectures.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:28 - The Part of PostgreSQL We Hate the Most
04:03 - Next steps for Postgres pluggable storage
05:58 - What does “a busy system” mean?
07:45 - Thinking Fast vs. Slow with Your Data in Postgres
09:43 - Running PostgreSQL on two ports
10:44 - Docker and sudden death for PostgreSQL
12:52 - Forcing a join order in PostgreSQL
14:42 - Waiting for Postgres 16: Logical decoding on standbys
15:08 - Understanding PostgreSQL Parallel Query
15:23 - Postgres 15 on Encrypted ZFS and Ubuntu 22.04 LTS
16:12 - auto_explain
16:25 - Hécate
16:36 - Outro
#postgres #postgresql
When are they going to fix the lack of indirect indexes?