What's new in ClickHouse 24.9

In this podcast episode, we dive into the latest release of ClickHouse and dissect the changelog. ClickHouse version 24.9 introduces significant improvements to security, usability, and performance. New features include multiple authentication methods per user, overlay string functions, and partition-level lightweight deletes. The update includes performance enhancements for JOIN operations, filesystem cache optimization, and parallel merge for the uniq aggregate function. It is essential to be aware of potential backward-incompatible changes, particularly around tuple expressions and replicated databases. Experimental features include dynamic JSON path introspection, improved refreshable materialized views, and a new min_max statistics type.