Timescale Blog

How percentile approximation works and why it's more useful than averages

What percentile approximations are, how percentiles work in PostgreSQL, and calculating them efficiently on time-series data.

Analyzing Cryptocurrencies Using PostgreSQL

Cryptocurrencies are fueling a modern day gold rush. Can data help us better understand this evolving market? Read the full article on the Tiger Data blog.

Multi-node TimescaleDB is now free

Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.

An update to the Timescale license

Learn how we are building an open-source business in the cloud and why we added the Timescale License. Read the full article on the Tiger Data blog.

Why SQL is beating NoSQL, and what this means for the future of data

After being left for dead, SQL is making a comeback and the NoSQL vs. SQL debate is stronger than ever. Why? And how will it impact the data community?

Building a distributed time-series database on PostgreSQL

Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.

Function pipelines: Building functional programming into PostgreSQL

Function pipelines allow you to analyze data by composing multiple functions in SQL and express complex logic in PostgreSQL in a cleaner way.

TimescaleDB raises $40M

We just raised a $40M Series B to bring our relational database for time-series to developers everywhere. Learn how we got started and what’s still yet to come.

Building a scalable time-series database on PostgreSQL

We just announced the release of TimescaleDB, a new open-source time-series database optimized for fast ingest and complex queries, now available on GitHub.

TimescaleDB vs. Amazon Timestream

Our TimescaleDB vs Amazon Timestream results surprised us, but after intensive testing, we found Timestream slow, expensive, and missing key capabilities.

Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

TimescaleDB 2.0 released, now distributed multi-node

Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.

Timescale Cloud: Multi-cloud, fully-managed time-series in AWS, Azure, and GCP

Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.

How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design

A discussion of aggregation in PostgreSQL and how it integrates with the design of Timescale’s hyperfunctions.

TimescaleDB vs. InfluxDB: built differently for time-series data

Get an in-depth look at how two leading time-series databases stack up. We compare data models, query language, reliability, performance, and more.

What time-weighted averages are and why you should care

Learn how time-weighted averages are calculated and why they’re so powerful for data analysis. Read the full article on the Tiger Data blog.

Building columnar compression in a row-oriented database

Read how we built a flexible, high-performance columnar compression mechanism for PostgreSQL to add scalability to our favorite database.

Postgres as the Substructure for IoT and the Next Wave of Computing

IoT applications generate torrents of data. Learn how - and why - to use TimescaleDB to scale PostgreSQL by 20x and harness its power for IoT.

Timescale raises $16M from Benchmark, NEA, Two Sigma Ventures

Humanity is now living with machines and swimming in machine data. Timescale just raised $16M to help developers, businesses, and society make sense of it all.

Timescale Announces New Database Cloud

Timescale Cloud provides a balance between a familiar developer platform and a flexible database for modern applications while retaining the ease.

First release candidate for TimescaleDB 1.0

Install TimescaleDB on Linux, macOS, Windows, Docker, Kubernetes, or from source

Faster DISTINCT queries on PostgreSQL

Learn common performance pitfalls and discover techniques to optimize your DISTINCT PostgreSQL queries. Read the full article on the Tiger Data blog.