DuckDB v2.0 vs 1.5.x: Benchmarks for IIoT Telemetry
DuckDB v2.0 brings a new PEG parser and async I/O: 2-3x faster Parquet/CSV scans, 40x faster recursive CTEs vs 1.5.5. Benchmarked for IIoT telemetry.
ClickHouse 26.8 LTS vs 26.3: Pipelined SQL, Iceberg Writes and Upgrade Risk
ClickHouse 26.8 LTS adds the pipe operator, Iceberg writes to S3 Tables, Puffin deletion vectors and atomic POPULATE. What to test before you upgrade.
Postgres 19 REPACK vs pg_repack vs VACUUM FULL: Online Table Maintenance Compared
Postgres 19 brings REPACK into core. How it compares to pg_repack and VACUUM FULL on locking, disk headroom, and failure recovery - plus what got cut from 19.