Time-Series Open Source Extension | Scaling Postgres 317

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.

Content Discussed

• Introducing pg_timeseries: Open-source time-series extension for PostgreSQL
• That time PostgreSQL said "no thanks, I don't need your index"
• Postgres Planner Quirks: How to fix bad JSONB selectivity estimates
• PostgreSQL Stories: From slow query to fast—via stats
• Geographically distributed Postgres for multi-tenant applications
• Minor releases
• Waiting for PostgreSQL 17 – MERGE / SPLIT partitions
• In-memory disk for PostgreSQL temporary files
• The Life of a Bug: From Customer Escalation to PostgreSQL commit
• What We’re Excited About PostgreSQL 17
• Scaling Clubhouse From 10K to 10 Million Users In 6 Months With Postgres
• PostgreSQL 17: part 4 or CommitFest 2024-01
• Incremental Backup In PostgreSQL 17
• Understanding Synchronous and Asynchronous Replication in PostgreSQL – What is Best for You?
• Optimizing SQL Queries - PostgreSQL best practices
• Understand PostgerSQL’s Portal – Executor vs Process Utility
• Deep Dive into PostgREST - Time Off Manager (Part 2)
• 16 Years After The Launch of 2ndQuadrant Italy: Remembering Simon Riggs
• New compilers, new timings
• Ship It Podcast — PostgreSQL with Andrew Atkinson
• RailsConf 2024 Conference — The Long Goodbye
• PGConf.DE 2024 - Review
• Introducing New Heroku Postgres Essential Plans Built On Amazon Aurora

YouTube Video

Podcast Audio