v.25.8Improvement

Support changing mv

Support changing mv insert settings on S3Queue table level. Added new S3Queue level settings: min_insert_block_size_rows_for_materialized_views and min_insert_block_size_bytes_for_materialized_views. By default profile level settings will be used and S3Queue level settings will override those. #83971 (Kseniia Sumarokova).
Introduced new settings to configure minimum insert block size on the S3Queue table level for materialized views.

Why it matters

This feature allows users to fine-tune insert block size thresholds specifically for S3Queue tables, enabling better control and optimization of data insertion into materialized views. By overriding profile-level defaults at the table level, it provides more granular performance tuning and resource management.

How to use it

Set the new S3Queue table-level settings min_insert_block_size_rows_for_materialized_views and/or min_insert_block_size_bytes_for_materialized_views to override the default profile-level insert block size settings for materialized views when using S3Queue tables.