v.25.8Improvement
Support changing mv
Support changing mv insert settings onS3Queuetable level. Added newS3Queuelevel settings:min_insert_block_size_rows_for_materialized_viewsandmin_insert_block_size_bytes_for_materialized_views. By default profile level settings will be used andS3Queuelevel settings will override those. #83971 (Kseniia Sumarokova).
Why it matters
This feature allows users to fine-tune insert block size thresholds specifically forS3Queue 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 newS3Queue 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.