Matvey Arye - Timescale Blog

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

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.

Blog

Rethinking the Database Materialized View as an Index

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

Product & Engineering

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

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

Product & Engineering

Optimizing queries on TimescaleDB hypertables with thousands of partitions

How 0.10 introduces 15x improvements in query planning times.

Blog

How to scale PostgreSQL 10 using table inheritance and declarative partitioning

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.