The Problem and the Solution
Understand why traditional databases struggle with time-series data
Tiger Data 101 → TimescaleDB | Section: What is TimescaleDB? | ⏱ Time: ~3 min
Learning objectives
Section titled “Learning objectives”By the end of this module, you will be able to:
- Recall key features and benefits of TimescaleDB (Remember)
- Explain how TimescaleDB extends PostgreSQL for time-series workloads (Understand)
The problem: data that never stops moving
Section titled “The problem: data that never stops moving”Most databases were built for data that sits still: a user record, a product listing, an invoice. But a huge class of real-world data is fundamentally different; it's a continuous stream of measurements over time.
Think of:
- A server reporting CPU usage every 10 seconds
- A smart meter recording energy consumption every minute
- A stock exchange ticking prices thousands of times per second
- A factory sensor logging temperature and pressure 24/7
This is time-series data: an ordered sequence of data points indexed by time. It has distinct characteristics that make traditional relational databases struggle:
| Challenge | Why it's hard for regular Postgres |
|---|---|
| High write volume | Thousands to millions of inserts per second |
| Data never updates | Append-only workloads waste row-based storage |
| Recent data is hottest | Queries almost always filter by time range |
| Old data can compress or expire | Lifecycle management needs to be automatic |
| Aggregations are expensive | Rolling averages, downsampling, done constantly |
Standard PostgreSQL can store time-series data, but without specialized tooling it becomes slow, expensive, and painful to manage at scale.
What is TimescaleDB?
Section titled “What is TimescaleDB?”TimescaleDB is an open-source database built for time-series workloads, built on top of PostgreSQL, not beside it.
The one-sentence version: TimescaleDB is PostgreSQL, supercharged for time-series data.
It's packaged as a PostgreSQL extension, which means:
- You get the full power of SQL (JOINs, indexes, transactions, foreign keys)
- Every PostgreSQL tool, driver, and ORM works out of the box
- You're not learning a new query language or giving up your existing stack
- You add time-series superpowers, not a new database
TimescaleDB is an open-source extension built by Tiger Data, first released in 2017. Tiger Cloud} is the fully managed cloud service for TimescaleDB.
TimescaleDB extends PostgreSQL—it doesn't replace it. Your existing PostgreSQL skills and tools transfer directly, with time-series optimizations on top.