cloudberry icon indicating copy to clipboard operation
cloudberry copied to clipboard
verified publisher icon apache

Enhanced materialized view in CBDB

Open my-ship-it opened this issue 2 years ago • 3 comments

We need to enhance materialized view in CBDB:

Automatically refresh mt view instead of manually.
Incremental refresh mt view.
Results reuse for mt view by planner

my-ship-it avatar Jul 31 '23 07:07 my-ship-it

https://github.com/orgs/cloudberrydb/discussions/36 IVM general summary

avamingli avatar Jul 31 '23 07:07 avamingli

Planner use Materialized Views Articles

Optimizing Queries Using Materialized Views: A Practical, Scalable Solution

avamingli avatar Aug 02 '23 03:08 avamingli

Automated Selection of Materialized Views and Indexes for SQL Databases

avamingli avatar Aug 07 '23 08:08 avamingli

Already supported

my-ship-it avatar Oct 09 '24 10:10 my-ship-it