Materialized views maintenance guidelines

Guidelines for using DSE materialized views.

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.
    Tip: 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.