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)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 thededuplicate_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.