Time-Series Open Source Extension | Scaling Postgres 317
Join Over 1,000 Engineers & Get New Episodes Weekly!
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