Speed Without Sacrifice: 37x Faster High Performance Ingestion, 42x Faster DELETES, Improved Continuous Aggregates Updates and More in TimescaleDB 2.21

TimescaleDB 2.21 introduces significant enhancements to the PostgreSQL-based database platform, focusing on optimizing performance and usability for time-series and real-time analytics workloads. This version debuts the Direct to Columnstore feature, allowing data to be ingested directly into an optimized columnar format, dramatically increasing ingestion speed and reducing I/O overhead. Enhancements in data management include faster UPSERTs and DELETEs, reduced bloat post-recompression, and the ability to split columnstore chunks. The update also improves Continuous Aggregates by enabling concurrent and batched refresh policies, reducing resource usage and enhancing data availability. TimescaleDB's usability improvements aim for a seamless user experience by simplifying the setup process and minimizing configuration requirements. Additionally, the release aligns with a new accelerated update cadence and supports recent PostgreSQL versions.