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

Perf: Add index to database to help calculating unaggregated fees in tap-agent #1027

Open
gusinacio opened this issue Oct 16, 2024 · 0 comments
Open

Perf: Add index to database to help calculating unaggregated fees in tap-agent #1027

gusinacio opened this issue Oct 16, 2024 · 0 comments
Labels
p1 perf Issues related to performance TAP

Comments

@gusinacio
Copy link
Member

gusinacio commented Oct 16, 2024 •
edited
Loading 

CREATE INDEX idx_scalar_tap_receipts_allocation_signer_timestamp_cast
ON scalar_tap_receipts ((allocation_id::text), (signer_address::text), timestamp_ns);

CREATE INDEX idx_scalar_tap_invalid_receipts_allocation_signer_cast
ON scalar_tap_invalid_receipts ((allocation_id::text), (signer_address::text));
@github-project-automation github-project-automation bot moved this to 🗃️ Inbox in Indexer Oct 16, 2024
@gusinacio gusinacio added p1 TAP perf Issues related to performance labels Oct 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
p1 perf Issues related to performance TAP
Projects
Indexer
Status: 🗃️ Inbox
Milestone
No milestone
Development

No branches or pull requests
1 participant
@gusinacio