„Materialized Views in PostgreSQL

A materialized view is a technique to „cache“ the results of a query when its result set is large or the query is very slow and that query is used very often. A materialized view is a set of query results stored in a table. Usually this means the results of a selection of a view. Queries involving aggregation are a good reason to have a materialized view. Usually a slow query is not a good reason to have a materialized view unless you have exhausted the best advice from pgsql-general and pgsql-performance. „

Materialized Views in PostgreSQL

Materialized Views in PostgreSQL

Von admin

Ähnlicher Beitrag

75 Gedanke zu “Materialized Views in PostgreSQL”

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert