TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning

TimescaleDB 2.27 introduces enhancements aimed at optimizing performance and efficiency in handling compressed data within analytical databases. The release significantly extends the use of bloom filters, which now accelerate UPDATE, DELETE, and UPSERT operations by pruning unnecessary decompression tasks, resulting in up to 160x more efficient operations. The Hypercore engine's vectorized execution path has been broadened, improving query execution speed by 30% to 2x for certain workloads. Additionally, continuous aggregates can now refresh and compress data within a single policy execution, simplifying operations and reducing overhead. Direct compression has become more adaptive, with automatic segmentby selection improving both efficiency and reliability. These advancements collectively aim to enhance TimescaleDB's ability to manage large datasets by reducing CPU usage and storage engine overhead while maintaining performance consistency.