Matvey Arye - Timescale 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

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

Optimizing queries on TimescaleDB hypertables with thousands of partitions

How 0.10 introduces 15x improvements in query planning times.

Engineering

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.