Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] Support for Materialized Views #10102

Closed
mheer9 opened this issue Sep 24, 2021 · 0 comments
Closed

[YSQL] Support for Materialized Views #10102

mheer9 opened this issue Sep 24, 2021 · 0 comments
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue

Comments

@mheer9
Copy link

mheer9 commented Sep 24, 2021

Jira Link: DB-745
This is a master issue for tracking the progress of MATERIALIZED VIEWS

Phase 1 - Support create, drop, refresh materialized view

Status Feature GitHub Issue Comments
CREATE, DROP Materialized View #10509 Handled like any other YB relation
REFRESH Materialized view (non-concurrent) #10510 We create a new relation which stores the updated data, and then we swap the storage of the old relation with that of the new relation

Phase 2 - Support concurrent refreshes

Status Feature GitHub Issue Comments
REFRESH Materialized View (concurrent) #10511 We load the data into a temporary relation, construct a diff relation of the new data and the old matview data, and perform deletes and inserts accordingly.

Phase 3 - Support alters

Status Feature GitHub Issue Comments
⬜️ ALTER Materialized View #10512
@mheer9 mheer9 added kind/new-feature This is a request for a completely new feature area/ysql Yugabyte SQL (YSQL) labels Sep 24, 2021
@yugabyte-ci yugabyte-ci added the priority/medium Medium priority issue label Jun 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/new-feature This is a request for a completely new feature labels Aug 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue
Projects
Status: Done
Development

No branches or pull requests

4 participants