Make account lookup with auth-addr filter instant.

[urtho]

Problem

Queries for accounts with auth-addr are slow¹.

Solution

• Add optional partial index that speeds up the query for accounts with auth-addr
• Modify the auth-addr filer query to make sure it includes the partial index for Postgres & CockroachDB (if enabled)

Footnotes

1. This is a placeholder issue - Nodely is going to do PR for that soon, following tests on light-indexer and fnet ↩

[7db9a]

Here is an algorand code chat service, taking a first-pass at the issue.

video of issue chat

Could this be useful for the community?

We compress the retrieval results, allowing it to feel like it was actual trained on the codebase specifically (even better as it can find the exact files like a needle in a haystack). Tightly integrated into git.

I have an interest in seeing the Algorand ecosystem succeed, as my company built an open source governance platform on Algorand (currently running in as a local test chain until we're comfortable for pub launch).

[urtho]

Wow, impressive. Incorrect but still impressive.

• auth field is actually named spend in the DB.
• Postgres might not consider the partial index unless the exact filter expression is also present in the queries.