TimescaleDB - Timeseries database for PostgreSQL
  • Products
  • Docs
  • Blog
  • Log into Timescale Cloud
    Log into Timescale Forge
    Try for free
9,084
Log In
Log into Timescale Cloud
Log into Timescale Forge
Try for free
Blog
Home Announcements Engineering Grafana Prometheus Newsletter Musings Developer Q&A
How to store time-series data in MongoDB, and why that’s a bad idea
Product & Engineering

How to store time-series data in MongoDB, and why that’s a bad idea

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

  • Rob Kiefer
    Rob Kiefer
  • Avthar Sewrathan
    Avthar Sewrathan
19 min read
Top 5 PostgreSQL Extensions
Blog

Top 5 PostgreSQL Extensions

At Timescale, we’re big fans of PostgreSQL. We asked our team and community to recommend their favorite PostgreSQL extensions. Here’s what they said...

  • Avthar Sewrathan
    Avthar Sewrathan
8 min read
TimescaleDB vs. InfluxDB: Purpose built differently for time-series data
Product & Engineering

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

An in-depth look into how two leading time-series databases stack up in terms of data model, query language, reliability, performance, ecosystem, operational management, and company/community support.

  • Mike Freedman
    Mike Freedman
  • Avthar Sewrathan
    Avthar Sewrathan
26 min read
Achieving the best-of-both worlds:  Ensuring up-to-date results with Real-Time Aggregation
Blog

Achieving the best-of-both worlds: Ensuring up-to-date results with Real-Time Aggregation

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.

  • Sven Klemm
    Sven Klemm
  • Mike Freedman
    Mike Freedman
14 min read
Time-series compression algorithms, explained
Blog

Time-series compression algorithms, explained

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.

  • Joshua Lockerman
    Joshua Lockerman
  • Ajay Kulkarni
    Ajay Kulkarni
13 min read
Our Product Team's Reading List: What Moral Psychology, the Rust Belt, and framing can teach us about UX
Blog

Our Product Team's Reading List: What Moral Psychology, the Rust Belt, and framing can teach us about UX

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.

  • Alex Thinath
    Alex Thinath
7 min read
CTO Corner: this month in data (April 2020 edition)
Blog

CTO Corner: this month in data (April 2020 edition)

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.

  • Mike Freedman
    Mike Freedman
3 min read
Homegrown monitoring for personal projects: Prometheus, TimescaleDB, and Grafana FTW
Blog

Homegrown monitoring for personal projects: Prometheus, TimescaleDB, and Grafana FTW

Learn how Tyler - one of our newest additions to the team - setup a "roll-your-own monitoring" solution with 10x storage savings – and how you can do the same, be it for your personal projects or a critical piece of business infrastructure.

  • Tyler Fontaine
    Tyler Fontaine
4 min read
Charting the spread of COVID-19 using data
Blog

Charting the spread of COVID-19 using data

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

  • Prashant Sridharan
    Prashant Sridharan
  • Avthar Sewrathan
    Avthar Sewrathan
11 min read
How to proactively manage long-term data storage with downsampling
Product & Engineering

How to proactively manage long-term data storage with downsampling

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

  • Bob Boule
    Bob Boule
6 min read
TimescaleDB 1.6: Data retention policies for continuous aggregates
Blog

TimescaleDB 1.6: Data retention policies for continuous aggregates

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

  • Team Timescale
    Team Timescale
4 min read
New: Helm Charts for deploying TimescaleDB on Kubernetes
Blog

New: Helm Charts for deploying TimescaleDB on Kubernetes

Quickly & easily add TimescaleDB to your Kubernetes deployment strategy

  • Bob Boule
    Bob Boule
3 min read
Recommendations for setting up your architecture with AWS & TimescaleDB
Product & Engineering

Recommendations for setting up your architecture with AWS & TimescaleDB

Learn more about common implementations and find the option that works best for your project, team, or organization

  • Bob Boule
    Bob Boule
6 min read
Optimize your storage costs with TimescaleDB’s data tiering functionality
Product & Engineering

Optimize your storage costs with TimescaleDB’s data tiering functionality

Gain significant improvements in Total Cost of Ownership by moving historical or infrequently accessed data to more cost effective storage.

  • Bob Boule
    Bob Boule
3 min read
Achieving optimal query performance with a distributed time-series database on PostgreSQL
Blog

Achieving optimal query performance with a distributed time-series database on PostgreSQL

Significant query performance benefits for both full and partial aggregations.

  • Erik Nordström
    Erik Nordström
11 min read
Create a data pipeline with TimescaleDB, Kafka, and Confluent
Blog

Create a data pipeline with TimescaleDB, Kafka, and Confluent

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

  • Bob Boule
    Bob Boule
8 min read
How to quickly build dashboards with time-series data
Product & Engineering

How to quickly build dashboards with time-series data

Achieve automated materialized views using TimescaleDB continuous aggregates.

  • Diana Hsieh
    Diana Hsieh
5 min read
Analyzing Bitcoin, Ethereum, and 4100+ other cryptocurrencies using PostgreSQL and TimescaleDB
Blog

Analyzing Bitcoin, Ethereum, and 4100+ other cryptocurrencies using PostgreSQL and TimescaleDB

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

  • Avthar Sewrathan
    Avthar Sewrathan
17 min read
Using AWS Lambda with Timescale Cloud for IoT Data
Product & Engineering

Using AWS Lambda with Timescale Cloud for IoT Data

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

  • Jeff Sposetti
    Jeff Sposetti
5 min read
How to benchmark IoT time-series workloads in a production environment
Blog

How to benchmark IoT time-series workloads in a production environment

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

  • Bob Boule
    Bob Boule
11 min read
Build an application monitoring stack with TimescaleDB, Telegraf & Grafana
Product & Engineering

Build an application monitoring stack with TimescaleDB, Telegraf & Grafana

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

  • Bob Boule
    Bob Boule
6 min read
Simplified time-series analytics using the time_bucket() function
Product & Engineering

Simplified time-series analytics using the time_bucket() function

Turn raw data into fixed time intervals for metric analysis and visualization in Grafana.

  • Diana Hsieh
    Diana Hsieh
4 min read
OrderedAppend: An optimization for range partitioning
Blog

OrderedAppend: An optimization for range partitioning

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

  • Sven Klemm
    Sven Klemm
4 min read
Implementing constraint exclusion for faster query performance
Blog

Implementing constraint exclusion for faster query performance

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

  • Sven Klemm
    Sven Klemm
7 min read
Storing and visualizing time-series data from a Raspberry Pi
Product & Engineering

Storing and visualizing time-series data from a Raspberry Pi

With the recent release of the Raspberry Pi 4 Model B, you can get faster CPU, 4K support, and up to 4GB of RAM. Coupled with the flexibility of Timescale Cloud, the possibilities are endless!

  • Matthew Perry
    Matthew Perry
  • Jeff Sposetti
    Jeff Sposetti
4 min read
  • Product
  • TimescaleDB
  • Features
  • Cloud Pricing
  • Get Started
  • Support
  • Security
  • Learn
  • Why time-series?
  • Documentation
  • Blog
  • Tutorials
  • Release notes
  • Success Stories
  • Webinars
  • Community
  • Slack
  • GitHub
  • Events
  • Office Hours
  • Heroes
  • Company
  • Newsroom
  • About
  • Careers
  • Contact
© Timescale, Inc. All Rights Reserved.
Privacy Policy