The new cost-based join optimizer with reordering support for non-inner joins
ClickHouse’s new exhaustive cost-based join optimizer safely reorders inner, outer, semi, and anti joins to find the cheapest valid plan.
AI NEWS JOURNAL
Search AI news
Search headlines, summaries and articles to connect the dots.
Chasing that 32 ms tail latency in ClickHouse
A customer saw an extra ~32 ms on simple SELECT queries after idle periods. We traced it to unbatched Native protocol metadata packets overflowing a reset TCP congestion window, reproduced it with network namespaces, and fixed it by batching them.
Executable UDFs are now generally available on ClickHouse Cloud
Executable UDFs are now generally available on ClickHouse Cloud across AWS, GCP, and Azure, with native runtimes, network access, observability, and API and Terraform support.