---
title: The Problem and the Solution | Tiger Data Docs
description: Understand why traditional databases struggle with time-series data
---

**Tiger Data 101** → TimescaleDB | **Section:** What is TimescaleDB? | **⏱ Time:** \~3 min

## 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

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?

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.

Note

TimescaleDB extends PostgreSQL—it doesn't replace it. Your existing PostgreSQL skills and tools transfer directly, with time-series optimizations on top.

---

→NEXT MODULE

[**How It Works** — Understand the core architecture and three pillars that make TimescaleDB powerful.](/learn/tiger-data-academy/tiger-data-101/what-is-timescaledb/core-architecture/index.md)