PGCon2019 - 3.4
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 |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
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.