TimescaleDB v2.20 - query performance and faster data updates
All new services created on Timescale Cloud are created using TimescaleDB v2.20. Existing services will be automatically upgraded during their maintenance window.
Highlighted features in TimescaleDB v2.20 include:
- Efficiently handle data updates and upserts (including backfills, that are now up to 10x faster).
- Up to 6x faster point queries on high-cardinality columns using new bloom filters.
- Up to 2500x faster DISTINCT operations with SkipScan, perfect for quickly getting a unique list or the latest reading from any device, event, or transaction.
- 8x more efficient Boolean column storage with vectorized processing, resulting in 30-45% faster queries.
- Enhanced developer flexibility with continuous aggregates now supporting window and mutable functions, plus customizable refresh orders.