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 cronjob for purging soft deleted data from db #99

Open
Pitasi opened this issue Apr 7, 2022 · 0 comments
Open

Add cronjob for purging soft deleted data from db #99

Pitasi opened this issue Apr 7, 2022 · 0 comments

Comments

@Pitasi
Copy link
Contributor

Pitasi commented Apr 7, 2022

With Tracelistener 1.4.0 we started soft deleting data instead of deleting the row entirely. This affects the following tables: delegations, unbonding_delegations, validators.

I don't personally think it's going to be a huge problem in the near future but we need to acknowledge that this data can grow over time and we can purge for good rows that have been deleted some time ago.

We can do that as a k8s cronjob, as a custom microservice, or even inside tracelistener if we want.

DoD:

  • periodically delete rows that have an "old" delete_height column (e.g. delete_height is older than current chain height - 100?) from all the tracelistener tables
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