Don't Forget Materialized Views — Stéphanie Baltus

Improve query performance by caching results with materialized views, a powerful feature in PostgreSQL, learn how to set up, refresh, and maintain them for optimal results.

Key takeaways

Materialized views can greatly improve query performance by caching results.
Refreshing materialized views can be done concurrently with the insert, ideally.
It’s easy to set up a materialized view in PostgreSQL, it’s just an extension that needs to be installed and then used.
To create a materialized view, you can use the create_table_as command, which is similar to creating a table.
Materialized views can be refreshed in batches, which can reduce the impact on the system.
The refresh process can be done incrementally, by comparing the previous and current data and only updating what has changed.
The materialized_view extension in PostgreSQL has an incremental mode, where it can refresh the view based on a set of rows that have changed.
Materialized views can be used to replace aggregated tables, which can improve query performance.
The author uses PostgreSQL 11 and has been using it since 2013.
The author has implemented materialized views in a production environment to improve query performance.
The author has experience with implementing materialized views in a production environment to improve query performance.
The author has made mistakes while implementing materialized views, such as not reading the documentation properly.
The author recommends reading the documentation carefully before implementing materialized views.
Materialized views can be used to cache results, which can improve query performance.
Materialized views can be used to replace views that are used in queries, which can improve query performance.
Materialized views can be used to improve the performance of complex queries that use window functions.
Materialized views can be used to improve the performance of queries that use subqueries.
Materialized views can be refreshed in real-time, which can provide users with fresh data.
The author’s company has implemented materialized views to improve query performance and has seen a significant improvement.
The author’s company has implemented materialized views to improve query performance and has seen a significant reduction in the time it takes to run queries.
The author’s company has implemented materialized views to improve query performance and has seen a significant improvement in the overall performance of the system.
Materialized views can be used to improve the performance of a system that is used by a large number of users.
Materialized views can be used to improve the performance of a system that is used by a large number of users simultaneously.
Materialized views can be used to improve the performance of a system that is used by a large number of users and is accessed frequently.

Don't Forget Materialized Views — Stéphanie Baltus

More talks