Materialized views maintenance guidelines

Follow these guidelines to ensure materialized view health and consistency:

Run anti-entropy repair on base tables with materialized views at least every gc_grace_seconds to ensure tombstones are propagated to materialized views and avoid the data resurrection problem.
Optionally, run periodic repairs on materialized views to detect and fix silent data corruption. Repairs on materialized views can be run at a lower periodicity than base tables.

Give Feedback