Answer
Materialized views require manual refresh. Concurrent refresh avoids locking but is slower. Used for analytics and reporting.
Quick Answer
Materialized view refresh strategies: REFRESH MATERIALIZED VIEW blocks all reads and writes during refresh. REFRESH MATERIALIZED VIEW CONCURRENTLY allows reads during refresh (requires unique index, takes longer). Automate refresh with pg_cron extension or external scheduler. For near-real-time data: trigger-based incremental refresh or logical replication to maintain the view. Choose refresh frequency based on staleness tolerance.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ