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.

Sign up for GitHub

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

Jump to bottom

Add migration to add latest_referenced_ledger to history lookup tables #4866

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

Add migration to add latest_referenced_ledger to history lookup tables #4866

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

Comments

@tamirms
Copy link
Contributor

tamirms commented May 4, 2023

We need to add a latest_referenced_ledger column and an index on that column to the following history lookup tables:

  • history_accounts
  • history_claimable_balances
  • histor_assets
  • history_liquidity_pools

For more context, see: Improving Reap Performance of History Lookup Tables
@tamirms tamirms mentioned this issue May 4, 2023
Closed
@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
Assignees
No one assigned
Labels
horizon
Projects
Platform Scrum
Status: Done
Milestone
No milestone
Development

No branches or pull requests
1 participant
@tamirms