---
title: "TimescaleDB — The #1 Time-Series Database"
description: "The time-series database built on Postgres. Automatic partitioning, columnar compression up to 95%, and 200+ native SQL functions. Open source with 22K+ GitHub stars."
url: "https://www.tigerdata.com/timescaledb"
---


# The #1 Time-Series Database

Keep sensor, on-chain, and customer data fresh, with compressed history and queryable real-time analytics at production scale.

- 100% PostgreSQL compatible
- Open source
- 12,000+ Developer community

## Core Capabilities

### Automatic Partitioning

Hypertables turn any Postgres table into a table automatically partitioned by time or id for fast ingest and predictable queries.

- Partition skipping at query planning
- Efficient index-only & skip-scans

### Row/columnar Hybrid Storage

Write fast with row storage. 
 Query fast with column storage. 
 Timescale handles the transition automatically as data ages.

- Auto-conversion between row/columnstore
- Vectorized operators with SIMD

### Compression (up to 95%)

Keep years of history online at a fraction of the cost, while making your analytical queries even faster.

- Delta, dictionary, and RLE encodings
- Direct filtering on compressed data

### Incremental Materialized Views

Our continuous aggregates (caggs) enable incrementally refreshed rollups for instant dashboards.

- Parallelized batched refreshes
- Real-time mode includes latest changes

### Automated Management

First-class automation for columnstore, retention, and aggregate refresh with full auditability.

- Built-in job scheduler with retries
- Configurable retention policies

### Time-series Functions

Hyperfunctions simplify fast, advanced time-series analysis using ~200 native SQL functions.

- Time-weighted averages & interpolation
- Partial aggregations eliminate reprocessing

## Trusted By

### Cloudflare

> "For many teams at Cloudflare, TimescaleDB strikes a phenomenal balance between the simplicity of storing your analytical data under the same roof as your configuration data, while also gaining much of the impressive performance of a specialized OLAP system."
>
> — Robert Cepa, Sr Software Engineer, Cloudflare

### Replicated

> “With Tiger Data's proven scalability and performance at its core, Replicated ensures that even as SecureBuild continues to grow, enterprises and developers alike will benefit from fast, dependable insights and hardened software delivery.”
>
> — Grant Miller, CEO, Replicated

### orca.so

> "Other vector databases and logging platforms were either too rigid, too expensive, or didn't allow us to keep things Postgres-native."
>
> — Founder, orca.so 

## Community

### 22.0K+ GitHub Stars

Contribute to the core engine, open issues, and shape the roadmap.

[Star on GitHub](https://github.com/timescale/timescaledb)

### 12,000+ Slack Members

Get help, share your architecture, and talk time-series with experts.

[Join our Slack](https://slack.timescale.com)