PostgreSQL, The Time-Series Database You Actually Want
Talkat JCON Europe 2023 · on Thursday, 2023-06-22· at 14:00· Cinema 7, Im Mediapark 1, 50670 Köln, Germany·
summary
Shows concrete numbers and techniques: NYSE produces 4.2 billion points/day (≈162k/sec) and legal retention pushes that into trillions, so storage and retention matter. Compares plain Postgres indexes and partitioning (index scan ~4 ms vs sequential ~50 ms), shows why declarative range partitioning beats inheritance and triggers, and demonstrates TimeScale hypertables auto-create daily/monthly chunks, smaller indexes, partition pruning, compression and incremental materialized views. Includes live demo behavior: automatic chunk creation, planner pruning, and when chunk size (day vs month) makes indexes useful or not.
AI-written summary · about
chapters (8)
- 0:00Introduction and speaker intro
- 8:47What is time series data
- 11:58Why use PostgreSQL for time series
- 16:18PostgreSQL partitioning explained
- 24:40Time series partitioning demos
- 38:15Time Scale vs PostgreSQL partitioning
- 44:22When to use Time Scale
- 46:06Q&A
related talks
51mPostgreSQL, The Time-Series Database You Want
39mTimescaleDB: Re-engineering PostgreSQL as a time-series database
53mEfficient Time Series with PostgreSQL
29mCatching Waves with Time-Series Data
51mBuilding a scalable time-series database on PostgreSQL
30mCatching Waves with Time-Series Data
13mTransform your business with time-series data (PRT061)
43mJust Use Postgres.