Skip to content
New issue

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

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

Already on GitHub? # to your account

Investigate using a lazy materialized view strategy for latest_data #715

Open
ericboucher opened this issue Apr 24, 2022 · 1 comment
Open

Comments

@ericboucher
Copy link
Member

Investigate using a lazy materialized view strategy for latest_data and avoid the need do fully refresh the materialized view (which takes a lot of time)

https://hashrocket.com/blog/posts/materialized-view-strategies-using-postgresql

@ericboucher
Copy link
Member Author

I think limiting the MV to 7 days helped a lot so this might not be needed. Good to know / consider in the future if the need arises.

See 8f99774

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

No branches or pull requests

1 participant