Efficient Time Series with PostgreSQL

Explore efficient time series data management using PostgreSQL in this 53-minute conference talk. Delve into the world of time series databases and discover how PostgreSQL, often overlooked, can be a powerful solution for storing and managing time series data at scale. Learn about data models, access patterns, and how to leverage PostgreSQL's general-purpose nature to reduce system complexity. Examine use cases in monitoring systems and IoT applications, and compare PostgreSQL's capabilities with bespoke time series database solutions. Gain insights into technical aspects such as indexing, data volume management, and partitioning strategies. Understand the advantages and potential challenges of using PostgreSQL for time series data, enabling you to make informed decisions about database selection for your projects.

Introduction
Use Case Monitoring
Common Components
Prometheus
Time Series
Mapping Time Series
Indexing
Btrees
Index
Data Volume
Adding Indexes
Normalisation
Index Scan
Increasing Data Volume
Clearing a billion rows
Partitioning
Splitting by Metric