Learn more about TimescaleDB

High Availability and Scalable Reads in PostgreSQL

1 Mar 2024 14 min read

A detailed primer on scaling PostgreSQL via streaming replication.

Understanding PostgreSQL Aggregation and Hyperfunctions’ Design

11 Jan 2024 19 min read

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

Quickly Building SQL Dashboards for Time Series With Continuous Aggregates

19 Dec 2023 5 min read

A tutorial on building dashboards for time-series data with continuous aggregates.

Best Practices for Query Optimization on PostgreSQL

8 Dec 2023 8 min read

Explore the optimization of PostgreSQL queries using tactics such as efficient indexing and partitioning, and judicious use of data types.

TimescaleDB vs. InfluxDB: Purpose Built Differently for Time-Series Data

18 Jul 2023 26 min read

An in-depth look into how TimescaleDB and InfluxDB stack up in terms of data model, query language, reliability, performance, ecosystem, operational management, and company/community support.

Move Fast, but Don’t Break Things: Introducing the Experimental Schema (With New Experimental Features) in TimescaleDB 2.4

3 Aug 2021 11 min read

To reinforce our commitment to moving fast and not breaking things, we are introducing a new experimental schema as part of our release of TimescaleDB 2.4.

How to Store Time-Series Data in MongoDB and Why That’s a Bad Idea

17 Dec 2020 19 min read

TimescaleDB vs MongoDB: 260 % higher insert performance, up to 54x faster queries, and simpler implementation for time-series data.

Achieving the Best of Both Worlds: Ensuring Up-To-Date Results With Real-Time Aggregation

7 May 2020 14 min read

Real-time aggregates (released with TimescaleDB 1.7) build on continuous aggregates' ability to increase query speed and optimize storage. Learn what's new, details about how they work, and how to get started.

Time-Series Compression Algorithms, Explained

22 Apr 2020 13 min read

Delta-delta encoding, Simple-8b, XOR-based compression, and more - these algorithms aren't magic, but combined they can save over 90% of storage costs and speed up queries. Here’s how they work.

Our Product Team's Reading List: What Moral Psychology, the Rust Belt, and Framing Can Teach Us About UX

17 Apr 2020 7 min read

Like many people, we've been catching up on our book backlog –and we're sharing our recent reads, plus what they've taught us about our work as product managers and engineers.

CTO Corner: This Month in Data (April 2020 Edition)

7 Apr 2020 3 min read

Mike Freedman, Timescale CTO, shares some of the most interesting articles and papers about databases and distributed systems he's found in the past month.

Charting the Spread of COVID-19 Using Data

5 Mar 2020 11 min read

Data gives us insight into the world around us. Using data, we can visualize and prepare for the spread of the COVID-19 pandemic.

How to Proactively Manage Long-Term Data Storage With Downsampling

23 Jan 2020 6 min read

Eliminate the need to store billions of rows with TimescaleDB’s upgraded continuous aggregates

TimescaleDB 1.6: Data Retention Policies for Continuous Aggregates

15 Jan 2020 4 min read

New release allows you to save resources and storage space while maintaining continuous aggregates

Helm Charts for Deploying TimescaleDB on Kubernetes

12 Dec 2019 3 min read

Quickly and easily add TimescaleDB to your Kubernetes deployment strategy.

Build a Data Pipeline With Apache Kafka and TimescaleDB

17 Oct 2019 8 min read

Ingest time-series data into TimescaleDB from upstream sources using Apache Kafka and Confluent Platform.

Analyzing Bitcoin, Ethereum, and 4,100+ Other Cryptocurrencies Using PostgreSQL and TimescaleDB

19 Sep 2019 17 min read

After a Crypto Winter in 2018, cryptocurrencies today are resurging. How can data help us better understand the Crypto Revival?

Using AWS Lambda With Managed Service for TimescaleDB for IoT Data

12 Sep 2019 5 min read

While it's already quite easy to get started with AWS Lambda and TimescaleDB, here are some tips & tricks to help with your integration.

How to Benchmark IoT Time-Series Workloads in a Production Environment

28 Aug 2019 11 min read

New IoT dataset available for benchmarking TimescaleDB, MongoDB, InfluxDB, Cassandra & others.

Build an Application Monitoring Stack With TimescaleDB, Telegraf & Grafana

15 Aug 2019 6 min read

Match the flexibility and scale of your application with a stack that works for you.

Simplified Time-Series Analytics Using the time_bucket() Function

8 Aug 2019 3 min read

Time-series analytics is now simpler: turn raw data into fixed intervals for metric analysis and visualization in Grafana.

OrderedAppend: An optimization for range partitioning

31 Jul 2019 4 min read

With this feature, we’ve seen up to 100x performance improvements for certain queries.

Implementing constraint exclusion for faster query performance

23 Jul 2019 7 min read

How we leveraged the foundation of PostgreSQL and extended its capabilities to improve performance.

Product & Engineering

Recommendations for Setting Up Your Architecture With AWS & TimescaleDB