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

add a support for pg_ivm ? #377

Closed
buncis opened this issue Jan 15, 2023 · 1 comment
Closed

add a support for pg_ivm ? #377

buncis opened this issue Jan 15, 2023 · 1 comment

Comments

@buncis
Copy link

buncis commented Jan 15, 2023

https://github.com/sraoss/pg_ivm

Incremental View Maintenance (IVM) is a way to make materialized views up-to-date in which only incremental changes are computed and applied on views rather than recomputing the contents from scratch as REFRESH MATERIALIZED VIEW does. IVM can update materialized views more efficiently than recomputation when only small parts of the view are changed.

I think I could make it work for my own fork, but its better to merged, but I never make a big pull request before, never write a test

willing to do it though just need a guidance

@derekprior
Copy link
Contributor

my gut reaction here is that it would likely be best for pg_ivm support to be created in a custom adapter that inherits from our Postgres adapter and overrides the necessary materialized view schema methods.

We only maintain the Postgres adapter but there are several other gems (see README) that implement adapters of their own. I'd suggest this path to start.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants