PostgreSQL - Views and Materialized Views
Why might a materialized view become outdated, and how does PostgreSQL handle this?
Why might a materialized view become outdated, and how does PostgreSQL handle this?
hard📝 Conceptual Q10 of 15
Step-by-Step Solution
Solution:
Step 1: Understand data freshness in materialized views
Materialized views store snapshots; base table changes do not auto-update them.Step 2: PostgreSQL refresh behavior
PostgreSQL requires manual REFRESH MATERIALIZED VIEW to update data.Final Answer:
Because base tables change; PostgreSQL requires manual refresh -> Option DQuick Check:
Materialized views = manual refresh after base changes [OK]
Quick Trick: Materialized views need manual refresh after base table changes [OK]
Common Mistakes:
- Assuming automatic updates on base table changes
- Thinking materialized views delete base tables
- Believing PostgreSQL locks views during updates
Master "Views and Materialized Views" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes