citusdata / citusdata/citus

PostgreSQL "better" materialized views

Open
#43 0 comments 0 reactions 0 assignees View on GitHub
feature
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

PostgreSQL's materialized views don't get updated on-demand. Users need to refresh a materialized view, and the [refresh command](http://www.postgresql.org/docs/current/static/sql-refreshmaterializedview.html) discards old contents and completely replaces the contents of a materialized view.

Commercial databases incrementally update a materialized view's contents -- this is particularly helpful for aggregate queries. This task involves improving PostgreSQL's materialized views for incremental updates.

Contributor guide

Open the contributing guide

Research direction

Start with the PostgreSQL REFRESH MATERIALIZED VIEW documentation linked in the issue and compare its full-replacement behavior with the requested incremental updates. Identify the Citus entry points and tests for materialized-view refresh behavior; done means supporting incremental updates, including for aggregate queries, without discarding all existing contents.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.