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 a new time-series open source extension called pg_timeseries, Postgres ignoring indexes, JSONB selectivity issues, and geographically distributed multi-tenant applications.
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:30 - Introducing pg_timeseries: Open-source time-series extension for PostgreSQL
03:25 - That time PostgreSQL said "no thanks, I don't need your index"
05:26 - PostgreSQL Performance Starter Kit
05:45 - Postgres Planner Quirks: How to fix a bad JSONB selectivity estimates
05:59 - PostgreSQL Stories: From slow query to fast-via stats
08:00 - Geographically distributed Postgres for multi-tenant applications
10:09 - Minor releases
11:10 - Waiting for PostreSQL 17-MERGE/SPLIT partitions
12:09 - In-memory disk for PostgreSQL temporary files
12:47 - The Life of a Bug: From Customer Escalation to PostgreSQL commit
13:34 - What We're Excited About PostgreSQL 17
14:14 - Scaling Clubhouse From 10K to 10 Million Users In Months with Postgres
14:30 - Outro
#postgres #postgresql