v.20.1New Feature

Add deduplicate_blocks_in_dependent_materialized_views option

Add deduplicate_blocks_in_dependent_materialized_views option to control the behaviour of idempotent inserts into tables with materialized views. This new feature was added to the bugfix release by a special request from Altinity. #9070 (urykhy)
Added the deduplicate_blocks_in_dependent_materialized_views setting to control how idempotent inserts are handled in tables with dependent materialized views.

Why it matters

This feature addresses the need for precise control over deduplication behavior when performing idempotent inserts into tables that have materialized views dependent on them. It helps prevent unwanted duplicate data in materialized views, improving data consistency and reliability.

How to use it

Users can enable or disable this feature by setting the deduplicate_blocks_in_dependent_materialized_views option in their server configuration or query settings. Adjust the setting based on the desired deduplication behavior during inserts into the base tables with dependent materialized views.