search

apache / cloudberry

Cloudberry Database - Open source alternative to Greenplum Database. Created by the original Greenplum developers.
https://cloudberrydb.org/
Apache License 2.0
403 stars 100 forks source link

Enhanced materialized view in CBDB #105

Closed my-ship-it closed 1 month ago

my-ship-it commented 1 year ago

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
avamingli commented 1 year ago

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

avamingli commented 1 year ago

Planner use Materialized Views Articles

Optimizing Queries Using Materialized Views: A Practical, Scalable Solution

avamingli commented 1 year ago

Automated Selection of Materialized Views and Indexes for SQL Databases

my-ship-it commented 1 month ago

Already supported