Conference 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.


Yugo Nagata