Timescale Blog

Best Practices for Time-Series Data Modeling: Single or Multiple Partitioned Table(s) a.k.a. Hypertables

9 Mar 2023 9 min read

Time-series data is relentless, so you know you’ll have to create one or more partitioned tables (a.k.a. Timescale hypertables) to store it. Learn how to choose the best data modeling option for your use case—single or multiple hypertables.

The Power of Linked Data Event Streams and Timescale for Real-Time Management of Time-Series Data

8 Mar 2023 8 min read

Learn how to consume a Linked Data Event Stream and store it in a Timescale database.

A PostgreSQL Developer’s Perspective: Five Interesting Patches From January’s Commitfest

7 Mar 2023 6 min read

In this recap of January’s Commitfest, our PostgreSQL developer Chris Travers shares his thoughts on improvements to psql, software development with infinite values, transaction ID wraparound problems, and more.

Want to learn how to use TimescaleDB?

Visit our comprehensive docs with API reference, user guides, tutorials, and much more.

Go to docs

Downsampling in the Database: Processing Data With Ruby or SQL?

2 Mar 2023 1 min read

One way to optimize your data processing is by improving data locality when downsampling your data. Watch this talk at RubyConfTH, where we benchmark downsampling data in Ruby against a SQL version powered by Timescale’s hyperfunctions.

A Guide to PostgreSQL Views

1 Mar 2023 3 min read

Understanding PostgreSQL views and materialized views is essential to fully grasp one of the most popular features in Timescale that will save you time and disk space: continuous aggregates.

How Ndustrial Is Providing Fast Real-Time Queries and Safely Storing Client Data With 97 % Compression

28 Feb 2023 15 min read

Read how Ndustrial is helping its clients save energy and money by collecting and connecting production and energy data to quickly answer real-time queries—all while using TimescaleDB to store and compress data up to 97 percent.

Do More on AWS With Timescale Cloud: Build an Application Using Lambda Functions in Python

24 Feb 2023 2 min read

Watch this step-by-step guide on creating a serverless time-series application consisting of two Lambda functions written in Python, using Timescale Cloud and AWS Lambda.

Got VPC? Here's Why You Use Them

21 Feb 2023 5 min read

Learn how VPCs work and why you should use them to help secure the services running your cloud-based application. We also highlight common use cases, including how to set up VPC peering between Timescale Cloud and AWS.

Downsampling in the Database: How Data Locality Can Improve Data Analysis

16 Feb 2023 8 min read

Learn why data locality can be crucial to downsampling data faster and more efficiently, accelerating the work of both devs and businesses. To test this new approach, we benchmarked the LTTB downsampling algorithm in Ruby and compared it with the Timescale Toolkit lttb ().

Do More on AWS With Timescale Cloud: VPC Peering

15 Feb 2023 1 min read

Watch how you can use Timescale Cloud and AWS services without exposing your valuable or sensitive time-series data to the public internet.

How Everactive Powers a Dense Sensor Network With Virtually No Power at All

14 Feb 2023 9 min read

Read how Everactive consolidated its storage solution and benefited from more predictable pricing by moving its metadata from Amazon RDS to Timescale Cloud—all while expanding its cloud analytics platform powered by battery-free sensors to developers building their own solutions and services.

What Is a Time-Series Database and Why Do You Need One?

10 Feb 2023 9 min read

Learn what a time-series database is and why time-series (or timestamped) data requires a specialized database to store it.

Timescale Timeout: The History and Basics of PostgreSQL

7 Feb 2023 1 min read

Learn more about PostgreSQL in this episode of Timescale Timeout: how it was created, its use cases, behind-the-scenes stories, and starter (to more advanced) tips.

Best Practices for Time-Series Data Modeling: Narrow, Medium or Wide Table Layout

31 Jan 2023 11 min read

Learn more about data modeling and the underlying data storage when using Timescale hypertables. In this blog post, we cover the three main table design options and explain why and how you should use them.

How Octave Achieves a High Compression Ratio and Speedy Queries on Historical Data While Revolutionizing the Battery Market

30 Jan 2023 7 min read

Read how Octave migrated from AWS Timestream to Timescale Cloud in search of a more scalable database and is revolutionizing the second-life battery market by collecting, analyzing, and storing large volumes of time-series data.

How TimescaleDB Solves Common PostgreSQL Problems in Database Operations With Data Retention Management

26 Jan 2023 10 min read

Poor partition management when handling data retention can lead to outages of your PostgreSQL database. Read how TimescaleDB solves this using lock minimization strategies.

The PostgreSQL Job Scheduler You Always Wanted (But Be Careful What You Ask For)

19 Jan 2023 7 min read

We created a job scheduler built into PostgreSQL with no external dependencies. This is the power you always wanted, but with a few caveats.

An Incremental Materialized View on Steroids: How We Made Continuous Aggregates Even Better

18 Jan 2023 5 min read

A continuous aggregate is similar to a PostgreSQL materialized view, speeding up queries. But rolling up (or downsampling) previously rolled up data can increase calculation speed while decreasing storage needs. Say hi to continuous aggregates on continuous aggregates, courtesy of TimescaleDB 2.9.

PostgreSQL, the Time-Series Database You Want

Migrating From Amazon RDS to Timescale Cloud