• Sources: primary
  • Summary: ClickHouse 26.10, published 2026-11-06, contains 104 new features, 225 performance optimizations and 739 bug fixes. A function composition operator lets higher-order function lambdas be written as pipelines joined with the pipe character, with placeholders for extra arguments. Quotas gain a written_rows counter so a user can be capped by rows inserted per interval. IN subquery sets can now spill to disk via max_bytes_before_external_set, which in the release's own example completed a query at 203 MiB peak memory that otherwise failed under a 512 MiB limit. A sql_compatible_division_for_integers setting makes integer division truncate as PostgreSQL does, and is off by default.
  • Why it matters: The spill setting lets large IN subqueries finish under tight memory limits instead of aborting, and row quotas give a per-user ingestion brake.
  • Background: ClickHouse evaluates IN with a subquery by materializing the subquery results into an in-memory set and probing outer rows against it, so set size has historically been bounded by max_memory_usage. External spilling mirrors what the engine already does for GROUP BY and sorting. Quotas in ClickHouse are time-interval limits attached to users or roles and visible in system.quotas_usage.