This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2018

Implementing Incremental View Maintenance on PostgreSQL

Date: 2018-10-26
Time: 09:30–10:20
Room: Casablanca
Level: Intermediate

PostgreSQL has supported materialized views since 9.3. This feature is used to speed up query evaluation by storing the results of specified queries. One problem of materialized view is its refresh. Corresponding data of materialized views have to be brought up to date when the underling base relations are updated. This technique is called Incremental View Maintenance (IVM) but this is not implemented in PostgreSQL yet.

In this talk, we will introduce some studies about IVM and discussions about implementing this on PostgreSQL. One of these researches proposed that efficient IVM is possible by assuming the existence of primary keys on base relations and materialized view. In contrast, we are proposing a method for IVM in which views don't have to have primary keys. In this talk, we will show our idea and Proof of Concept example to explain our idea.


The following slides have been made available for this session:


Yugo Nagata