Postgresql easy
In a PostgreSQL environment, what functional characteristic distinguishes a `MATERIALIZED VIEW` from a standard `VIEW`?
- A Standard Views allow for full character-level editing via the `psql` interactive terminal tool.
- B Materialized Views store data physically on disk, while standard Views compute data on-the-fly.
- C Standard Views are automatically deleted whenever the underlying source table is vacuumed.
- D Materialized Views bypass the permission system and are visible to all users in the cluster.
Answer: B. Materialized Views store data physically on disk, while standard Views compute data on-the-fly.
Materialized views act like a snapshot/cache on disk. They offer massive read speed for complex queries but must be manually or periodically 'Refreshed' to reflect changes in the underlying source data.
One system design question a day, with spaced repetition so the ones you miss come back.
Get the appRelated questions
- Which standard PostgreSQL utility is designed to extract a single database into a script or archive file for backup purposes?
- Why would PostgreSQL reject a `DELETE` operation on a record despite the user having full administrative privileges?
- The 'Heap Only Tuples' (HOT) optimization improves UPDATE performance. Which specific set of conditions must be met for a HOT update to occur?
- Which native command-line utility is used to execute SQL queries and manage PostgreSQL databases from a terminal session?
- What is the specific purpose of 'Freezing' a row (modifying its `xmin` status) during a major VACUUM operation?
- In the context of PostgreSQL storage management, what is the primary objective of the `VACUUM` command?