Product Updates - Timescale Blog

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.

What's New in TimescaleDB 2.9?

18 Jan 2023 3 min read

Continuous aggregates on continuous aggregates, fixed schedules for background jobs, and improved hyperfunctions and multi-node configuration: here’s what you can find in TimescaleDB 2.9.

How to Design a Better Developer Experience for Time-Series Data: Our Journey With Timescale's Cloud UI

6 Dec 2022 17 min read

Designing a delightful, user-centered UI is a huge part of building a seamless developer experience for time-series data. Join us on a journey through the evolution of the Timescale Cloud UI, as we share our latest upgrade and all the lessons we learned.

Expanding the Boundaries of PostgreSQL: Announcing a Bottomless, Consumption-Based Object Storage Layer Built on Amazon S3

16 Nov 2022 10 min read

Timescale Cloud now offers consumption-based, low-cost object storage built on Amazon S3, giving you more tools to build scalable applications cost-efficiently.

3 Big Reasons Why You Should Upgrade to the New Continuous Aggregates

25 Oct 2022 3 min read

Hello faster queries and decreased storage costs! Learn more about the three biggest benefits of migrating to the new Timescale continuous aggregates.

Nightmares of Time Zone Downsampling: Why I’m Excited About the New time_bucket Capabilities in TimescaleDB

29 Sep 2022 4 min read

Rolling up time-series data, also known as downsampling, often requires the user’s time zone to be taken into account, and TimescaleDB 2.8 makes it as simple as never before.

What’s New in TimescaleDB 2.8?

29 Sep 2022 3 min read

This major release is loaded with improvements to time_bucket, continuous aggregates policies, distributed hypertables querying, and more.

How We Fixed Long-Running PostgreSQL now( ) Queries (and Made Them Lightning Fast)

22 Jun 2022 7 min read

Help requests about slowdowns in PostgreSQL now( ) queries are a thing of the past. Learn how we fixed it in TimescaleDB 2.7 for lightning-fast performance (up to 400x faster!).

Identify Slow PostgreSQL Queries with pg_stat_statements

30 Mar 2022 11 min read

Goodbye, bottlenecks. Hello, performance. Use the pg_stat_statements PostgreSQL extension to uncover performance issues in Timescale Cloud.

Introducing One-Click Database Forking in Timescale Cloud

29 Mar 2022 7 min read

Create a copy of your database in one click, enabling easier creation of testing environments, snapshots of data, maintenance of up-to-date staging environments, safer upgrades, and more.

High Availability for Your Production Environments: Introducing Database Replication in Timescale Cloud

28 Mar 2022 12 min read

Timescale Cloud now supports database replication, allowing you to significantly reduce potential downtime in your production database in case of failure and to improve performance through the use of read replicas.

Increase Your Storage Savings With TimescaleDB 2.6: Introducing Compression for Continuous Aggregates

23 Feb 2022 12 min read

Timescale 2.6 is now available, introducing two highly requested features by our community: compression for continuous aggregates and timezone support for continuous aggregates (the latter under experimental).

One-Click Multi-Node TimescaleDB: Announcing the Support for Multi-Node Deployments in Timescale Cloud

1 Nov 2021 7 min read

Timescale Cloud now supports the fast and easy creation of multi-node deployments, enabling developers to easily scale the most demanding time-series workloads.

Massive Scale for Time-Series Workloads: Introducing Continuous Aggregates for Distributed Hypertables in TimescaleDB 2.5

28 Oct 2021 13 min read

With this release, we introduce continuous aggregates in multi-node TimescaleDB, support for Postgres 14, and support for time zones in time_bucket_ng (under experimental).

Grow Worry-Free: Storage Autoscaling on Timescale Cloud

7 Oct 2021 6 min read

Available today in Timescale Cloud: Automatically increase database storage as your application grows, while instituting cost constraints to make sure you stay within budget.

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

3 Aug 2021 14 min read

To reinforce our commitment to moving fast and not breaking things, we are introducing a new experimental schema for TimescaleDB as part of our release of TimescaleDB 2.4. Read on for more about how Timescale resolves the tension between rapid innovation and stability.

TimescaleDB 2.3: Improving Columnar Compression for Time-Series on PostgreSQL

26 May 2021 9 min read

TimescaleDB 2.3 makes built-in columnar compression even better by enabling inserts directly into compressed hypertables, as well as automated compression policies on distributed hypertables.

TimescaleDB 1.7: fast continuous aggregates with real-time views, PostgreSQL 12 support, and more Community features

24 Apr 2020 3 min read

We're excited to announce TimescaleDB 1.7, which includes two major updates: PostgreSQL 12 support and Real-time Aggregates, as well as new capabilities in our Community edition 🥳! Get a quick look at what's new and how to get started.

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