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_secondsto ensure tombstones are propagated to materialized views and avoid the data resurrection problem.
Enable NodeSync on base tables with materialized views. See Enabling NodeSync validation.
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.
Use the NodeSync
deadline_target_secparameter to control the periodicity at which data is validated on base tables and materialized views. See Setting the NodeSync deadline.