Matvey Arye - Timescale Blog

Promscale: An analytical platform and long-term store for Prometheus, with the combined power of SQL and PromQL

6 Oct 2020 14 min read

We just announced Promscale: a new open-source analytical platform & long-term store for Prometheus, with the combined power of SQL and PromQL. Learn why we built it, how it works, and how to get started right away.

Rethinking the Database Materialized View as an Index

12 Jun 2019 4 min read

By utilizing the properties of time-series data, can we make the maintenance of materialized views efficient enough so they act like indexes?

SQL vs. Flux: Choosing the right query language for time-series data

2 Aug 2018 10 min read

An examination of the strengths and weaknesses of SQL, and why query planners exist, by way of comparing TimescaleDB and InfluxDB.

Optimizing queries on TimescaleDB hypertables with thousands of partitions

27 Jun 2018 3 min read

How 0.10 introduces 15x improvements in query planning times.

How to scale PostgreSQL 10 using table inheritance and declarative partitioning

8 Nov 2017 11 min read

PG10 introduces quite a few substantial new features: logical replication, full text search support for JSON / JSONB, cross-column statistics, and better support for parallel queries. Overall, PG10 is a significant milestone in the steady development of a venerable open-source database.