v.18.14New Feature

Parallel Processing for MATERIALIZED VIEWS in ClickHouse

Official CH changelog text
Parallel processing is available for many MATERIALIZED VIEWs when inserting data. See the parallel_view_processing setting. Marek Vavruša
Introduces parallel processing for many MATERIALIZED VIEWs during data insertion using the parallel_view_processing setting.

Why it matters

This feature improves the efficiency and speed of data insertion operations that involve MATERIALIZED VIEWs by enabling parallel processing. It reduces bottlenecks caused by sequential processing and optimizes resource utilization, enhancing overall performance.

How to use it

Users can enable parallel processing for MATERIALIZED VIEWs by setting the parallel_view_processing parameter to 1 in the server configuration or session settings. For example:

SET parallel_view_processing = 1;

This activates parallelism during insert operations involving materialized views.

Related resources

PreviousNext