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. -
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_sec
parameter to control the periodicity at which data is validated on base tables and materialized views. See Setting the NodeSync deadline.