Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 22, 2019
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.