TimescaleDB 2.28: Faster Queries, Lighter Operations, and Better Schema Evolution

TimescaleDB 2.28 introduces several enhancements aimed at reducing operational friction and improving performance in time-series analytics, particularly for continuous aggregates and compressed data queries. The release focuses on making analytical queries faster without code changes, simplifying continuous aggregate operations, and allowing schema evolution without the need for extensive rebuilds. Key improvements include the use of bloom filters to reduce redundant processing, expansion of vectorized execution, and the ability to add new aggregation columns in place. It also introduces fine-grained locking, incremental refresh batching, and metadata-driven queries to speed up operations while maintaining flexibility. Additionally, the update supports better operational efficiency through sparse index retrofitting and compression settings clarity, with a transition plan for PostgreSQL 15 users to upgrade to newer versions. These changes enable users to evolve their analytics alongside their applications as they scale, ensuring faster queries and lighter operations.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.