Schedule - pgDay Paris 2019

Don't forget the Materialized Views

Date: 2019-03-12
Time: 11:50–12:15
Room: Auditorium

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.


The following slides have been made available for this session:


Stéphanie Baltus