Timescale Blog

Timescale is an advanced cloud solution that utilizes PostgreSQL, specifically designed for managing time series data, events, and analytics.

National, Trade/B2B

English

Blog

Outlet metrics

Domain Authority

Ranking

Global

#150851

United States

#91993

Computers Electronics and Technology/Programming and Developer Software

#1984

Traffic sources

Monthly visitors

Articles

How to Set Up a Dashboard for Global Energy Data Analytics

2 months ago | timescale.com | Jônatas Davi Paganini |Ana Tavares

The intermittent energy project is a global energy grid analytics platform that processes and analyzes power grid data (a.k.a. time-series data) from over 40 countries. Created by Morgan Christiansson to test the assertion that “the wind is always blowing somewhere,” the project leverages publicly available energy data to shed light on energy transition discussions.
TimescaleDB in 2024: Making Postgres Faster

Jan 14, 2025 | timescale.com | James Blackwood-Sewell

If I had to summarize 2024 for Timescale, I’d call it the year of Postgres for AI. From game-changing open-source launches like pgvectorscale (a performance booster for large production vector workloads with PostgreSQL + pgvector) to pgai (which integrates Postgres with LLMs for AI app development), we pushed the boundaries of what developers can achieve with Postgres. But AI wasn’t the only story.
General-Purpose vs. Domain-Specific Embedding Models

Dec 20, 2024 | timescale.com | Jacky Liang

When building a search or RAG application, you face a crucial decision—which embedding model should you use? The choice is no longer just between proprietary models like OpenAI and open-source alternatives. Now, you also need to consider domain-specific models trained for particular fields like finance, healthcare, or legal text. Once you've identified potential candidates, the testing process begins.
What Is High Cardinality?

Dec 11, 2024 | timescale.com | Joshua Lockerman |Ana Tavares |Blagoj Atanasovski

If you are working with a database, especially with time-series data, then you have likely faced the challenge of handling high-cardinality data. In particular, time-series high cardinality is a common problem in industrial IoT (e.g., manufacturing, oil & gas, utilities), as well as some monitoring and event data workloads.
Counter Analytics in PostgreSQL: Beyond Simple Data Denormalization

Dec 4, 2024 | timescale.com | Jônatas Davi Paganini

If you've been working with PostgreSQL, you've probably seen memes advocating for denormalized counters instead of counting related records on demand. The debate usually looks like this:-- The "don't do this" approach: counting related records on demandSELECT COUNT(*) FROM post_likes WHERE post_id = $1;-- The "do this instead" approach: maintaining a denormalized counterSELECT likes_count FROM posts WHERE post_id = $1;Let's break down these approaches.
Continuous Aggregates

Dec 3, 2024 | timescale.com | Sarah Conway

When looking at reasons to use TimescaleDB, you’ll commonly see a feature called “continuous aggregates” mentioned. It’s a powerful feature that helps you see a massive improvement in performance when working with incredibly large or rapidly growing data sets, equipping PostgreSQL to handle real-time analytics workloads effortlessly. Let’s cover it in a little more detail. What Are Continuous Aggregates, Anyway?
Building a Better Ruby ORM for Time Series and Analytics

Nov 27, 2024 | timescale.com | Jônatas Davi Paganini

Rails developers know the joy of working with ActiveRecord. DHH didn’t just give us a framework; he gave us a philosophy, an intuitive way to manage data that feels delightful. But when it comes to time-series data, think metrics, logs, or events, ActiveRecord can start to feel a little stretched. Handling huge volumes of time-stamped data efficiently for analytics? That’s a challenge it wasn’t designed to solve (and neither was PostgreSQL). This is where TimescaleDB comes in.
Benchmarking PostgreSQL Batch Ingest

Nov 26, 2024 | timescale.com | James Blackwood-Sewell

In a previous article in this series, I explored the magic of INSERT...UNNEST for improving PostgreSQL batch INSERT performance. While it’s a fantastic technique, I know it’s not the fastest option available (although it is very flexible). Originally, I hadn't intended to loop back and benchmark all the batch ingest methods, but I saw a lot of confusion out there, so I'm back, and this time I'm looking at COPY too.
How WaterBridge Uses TimescaleDB for Real-Time Data Consistency

Nov 20, 2024 | timescale.com | Chris Morris |Ana Tavares |Isabel Macaulay |Hien Phan

This is an installment of our “Community Member Spotlight” series, in which we invite our customers to share their work, spotlight their success, and inspire others with new ways to use technology to solve problems. In this edition, Chris Morris, SCADA (Supervisory Control and Data Acquisition) Manager at WaterBridge, an Oil & Gas production water reuse and disposal company, shares how his team is using TimescaleDB.
A Dev's Intro to Hypertables

Nov 18, 2024 | timescale.com | Sarah Conway

As a PostgreSQL enthusiast, it’s been very interesting to join Timescale and learn about TimescaleDB, a PostgreSQL extension with numerous solutions for handling large volumes of data. While Timescale has excellent documentation, having a quick and easy getting started guide is always nice. Scaling PostgreSQL via partitioning is a challenge for many PostgreSQL users, but TimescaleDB has a core feature to help solve it.