How deeply does Just Use Postgres! cover materialized view?

Explains persistence, query behavior, creation, querying, stale results, and explicit refreshing through a complete sales example.

Materialized view

As explained in Just Use Postgres!

A materialized view is a query-defined relation whose result is persisted and remains unchanged until explicitly refreshed.

A materialized view is a query-defined relation whose result is persisted. Unlike an ordinary view, it does not execute the underlying query for every read; clients see the same result until an explicit refresh. This suits resource-intensive queries and reports that do not require current data. section 2.7

Monthly sales report

An e-commerce platform can persist monthly revenue and order totals with `CREATE MATERIALIZED VIEW sales.monthly_sales_summary AS ...`. After a new order, querying the view still returns the previous totals. Running `REFRESH MATERIALIZED VIEW sales.monthly_sales_summary;` recomputes the result, after which the report includes the new order.

How Just Use Postgres! covers it

liveBook manning.com

Read Just Use Postgres! on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

ScyllaDB in ActionA materialized view is a stored, automatically maintained representation of base-table data organized according to a different key or query access path.
liveBook manning.com

MongoDB 8.0 in Action, Third EditionA materialized view is a persistently stored result of a query or transformation that can be refreshed as source data changes.
liveBook manning.com

Kafka for ArchitectsA materialized view is a stored, continuously maintained representation of query results that can be read without recomputing the underlying query.
liveBook manning.com

Snowflake Data EngineeringA materialized view is a database object that stores the results of a query and maintains them for subsequent access.

Compare how 5 books explain materialized view →

Related concepts

continuous aggregateincludes · A continuous aggregate is a TimescaleDB query-result object that stores precomputed aggregate data and refreshes it incrementally according to a defined policy.
databasepart of · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
indexingincludes · Indexing is the organization or use of positions, keys, or lookup structures to identify and retrieve selected data or elements.

This explainer was generated by Manning's knowledge graph from the text of Just Use Postgres!. The section links point to the parts of the book it draws on.