Episode Details

This story was originally published on HackerNoon at: https://hackernoon.com/timescaledb-228-faster-queries-lighter-operations-and-better-schema-evolution.
TimescaleDB 2.28 speeds up time-series queries, makes continuous aggregates more flexible, and simplifies schema and compression changes at scale.
Check more stories related to undefined at: https://hackernoon.com/c/undefined. You can also check exclusive content about #timescaledb-2.28, #timescaledb-performance, #timescaledb-compressed-data, #continuous-aggregate-refresh, #time-series-analytics, #timescaledb-schema-evolution, #continuous-aggregate-database, #good-company, and more.

This story was written by: @tigerdata. Learn more about this writer by checking @tigerdata's about page, and for more stories, please visit hackernoon.com.

TimescaleDB 2.28 focuses on making large-scale time-series analytics faster and easier to operate. Continuous aggregates now support in-place schema changes, fine-grained locking, incremental refresh batching, and direct ANALYZE and VACUUM. Queries on compressed data also get faster through metadata-driven first() and last(), vectorized CASE expressions, and improved batch sorting. PostgreSQL 15 support ends with 2.28, so users should plan upgrades to PostgreSQL 16, 17, or 18.