Scaling Time-Series Workloads on Postgres
From Software Engineering Daily · · 48 min
This plays from the publisher's own server. We do not host a copy.
Description
Many real-world processes produce data as a continuous stream rather than as isolated records. Sensor readings, financial markets, and application telemetry all generate data this way. This kind of time-series data has a distinctive shape. It’s written far more often than it is updated, it accumulates continuously, and it is usually queried across ranges of time. Time-series databases are built specifically for this kind of workload.
TimescaleDB (https://www.tigerdata.com/timescaledb) is an open source database from Tiger Data (https://www.tigerdata.com/) that adds time-series capabilities to PostgreSQL. It’s implemented as a Postgres extension, so it introduces new functionality while preserving standard Postgres behavior and SQL. This lets a single Postgres-based system handle both transactional and analytical workloads without splitting data across multiple tools.
Brandon Purcell (https://www.linkedin.com/in/bpurcell/) is the Director of Product Management at Tiger Data. In this episode, Brandon joins Kevin Ball to discuss why time-series data breaks conventional databases, how hypertables and Hypercore scale Postgres, zero-copy database forking for agent-based workflows, and much more.
Full Disclosure: This episode is sponsored by Tiger Data
Sponsorship inquiries: sponsor@softwareengineeringdaily.com
The post Scaling Time-Series Workloads on Postgres (https://softwareengineeringdaily.com/podcasts/scaling-time-series-workloads-on-postgres/) appeared first on Software Engineering Daily (https://softwareengineeringdaily.com).