One challenge that Algorand (a cryptocurrency from MIT) has is that most queries on Blockchain data end up going through either the Rand Labs Postgres servers o

One challenge that Algorand (a cryptocurrency from MIT) has is that most queries on Blockchain data end up going through either the Rand Labs Postgres servers or PureStake's. This in my opinion is because there is no option for a partial index. The Postgres stores all transactions or none. So that makes it impractical to set up and run on cloud servers for most teams. They should have partial indexing and also really should have a decentralized Indexer in the long run.