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

Investigate use of partitioning for extremely large tables like log_play #1613

Open
clpetersonucf opened this issue Oct 2, 2024 · 0 comments

Comments

@clpetersonucf
Copy link
Member

Materia databases in a production environment accrue millions of rows in the log_play table across time. Performing queries against that data, even with indexed fields, can take excessively long amounts of time. We might consider looking into partitioning log_play based on created_at to keep recent (within a ~semester) data hot and rapidly available.

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

1 participant