Distributed IoT Telemetry Storage Based on PostgreSQL and TimescaleDB
summary
A presentation about building a distributed IoT telemetry storage using PostgreSQL and the TimescaleDB extension. It covers handling IoT telemetry data at scale by combining PostgreSQL’s relational capabilities with TimescaleDB’s time-series features to store and query large volumes of sensor/telemetry data.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 2:28TimescaleDB overview
- 8:23PostgreSQL extension
- 17:10Hypertables
- 23:50Hypertable example
- 24:55time_bucket
- 26:01Performance comparison
- 29:38Multi-node cluster
- 37:40Distributed hypertable
- 41:31IoT telemetry systems
- 41:51Limitations
- 44:18Visualization tools
- 46:03Q&A
related talks
51mBuilding a scalable time-series database on PostgreSQL
39mTimescaleDB: Re-engineering PostgreSQL as a time-series database
51mPostgreSQL, The Time-Series Database You Want
13mTransform your business with time-series data (PRT061)
49mIoTDB - Moving from Relational to Timeseries
42mAccessible Time Series data
25mHow the Tooth Fairy Manages Billions of Teeth with TimescaleDB
10mBuilding IoT Apps with JSONB & Timeseries