Conference Schedule - pgDay Paris 2019
Don't forget the Materialized Views
Time: 11:50 - 12:15
When exposing data to an user interface, we often find ourselves needing to speed up the response time. PostgreSQL offers plenty of solutions for that such as different types of indexes, parallel queries and so on. But since the 9.3 version, PostgreSQL also provides a nice feature: the materialized views. Easy to setup and maintain, they are often the best choice when it comes to caching a resultset. In this talk you will learn how to get the most of materialized views, understand their behaviour and then know how to use them wisely.