Sven Klemm - Timescale Blog

How we made DISTINCT queries up to 8000x faster on PostgreSQL

6 May 2021 13 min read

We love PostgreSQL and believe in the power of the platform and community. Like all databases, sometimes "basic" queries don't scale with very large datasets. TimescaleDB 2.2 provides up to 8000x faster DISTINCT queries thanks in part to our ability to extend PostgreSQL.

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.

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.

Mind the gap: Using SQL functions for time-series analysis

24 Jan 2019 6 min read

Write more efficient and readable queries with a new set of time-series analytic tools included in TimescaleDB 1.2

Grafana & TimescaleDB: Enhancing time-series exploration and visualization

16 Oct 2018 2 min read

The new graphical query editor in Grafana v5.3 for PostgreSQL offers a visual interface and TimescaleDB compatibility.