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

Reap lookup tables in DeleteUnretainedHistory #4868

Closed
tamirms opened this issue May 4, 2023 · 1 comment
Closed

Reap lookup tables in DeleteUnretainedHistory #4868

tamirms opened this issue May 4, 2023 · 1 comment
Labels

Comments

@tamirms
Copy link
Contributor

tamirms commented May 4, 2023

Update the reaping goroutine so that it deletes rows in the history lookup tables which are outside the retention window. This should be as simple as executing a DELETE statement like:

DELETE FROM history_accounts WHERE latest_referenced_ledger < $ledger_boundary;

For more context, see: Improving Reap Performance of History Lookup Tables

@tamirms
Copy link
Contributor Author

tamirms commented Sep 6, 2024

We decided to go with a different design: https://docs.google.com/document/d/1CGfBCS99MTEZDP4mMhV1o6Z5NE_Tlg7ENCcWTwzhlio/edit

@tamirms tamirms closed this as completed Sep 6, 2024
@github-project-automation github-project-automation bot moved this from Backlog to Done in Platform Scrum Sep 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: Done
Development

No branches or pull requests

1 participant