PGCon2019 - 1.0.10

PGCon 2019
The PostgreSQL Conference

Speakers
Yugo Nagata
Schedule
Day Talks - Day 2 - 2019-05-31
Room DMS 1110
Start time 15:00
Duration 00:45
Info
ID 1316
Event type Lecture
Track Hacking
Language used for presentation English

Toward Implementing Incremental View Maintenance on PostgreSQL

Incremental View Maintenance (IVM) is a technique to maintain materialized views which computes and applies only the incremental changes to the materialized views to make refresh more efficient, but this is not implemented on PostgreSQL yet. In this talk, we will discuss what is necessary to implement IVM and our idea about the first version of IVM implementation on PostgreSQL.

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 maintenance. Materialized views have to be brought up to date when the underling base relations are updated.

Incremental View Maintenance (IVM) is a technique to maintain materialized views which computes and applies only the incremental changes to the materialized views rather than recomputing the contents as the current REFRESH command does. This feature is not implemented on PostgreSQL yet.

In this talk, after introducing some studies and discussions about IVM including our PoC (Proof of Concept) implementation, we will discuss what is necessary to implement this on PostgreSQL. For example, we have to decide how to extract changes on base tables, how to compute the delta to be applied to materialized views, when to maintain materialized views, and so on. Also, I will show our idea about the first version of IVM implementation on PostgreSQL.