For AI agents: the complete documentation index is at llms.txt. Every page is also available as markdown by appending .md to its URL, or by sending an Accept: text/markdown request header.

Materialized views

These settings control materialized view SQL support and the background refresh job. Materialized views can use dedicated worker threads or share the server's common pool.

cairo.mat.view.enabled​

  • Default: true
  • Reloadable: no

Enables or disables SQL support and the refresh job for materialized views.

cairo.mat.view.parallel.sql.enabled​

  • Default: true
  • Reloadable: no

When disabled, SQL executed by the materialized view refresh job always runs single-threaded.

mat.view.refresh.worker.affinity​

  • Default: equal to the CPU core count
  • Reloadable: no

Comma-separated list of numerical CPU core indexes.

mat.view.refresh.worker.count​

  • Default: 0
  • Reloadable: no

Number of dedicated worker threads assigned to refresh materialized views. When 0, uses the shared worker pool.

mat.view.refresh.worker.haltOnError​

  • Default: false
  • Reloadable: no

Flag that indicates if the worker thread must stop when an unexpected error occurs.