News for hackers. Stuff that matters.
Re:Optimizing Postgres queries at scale by ilaksh on Wednesday December 29, 2021 @07:47AM (#29724313)
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.

There are no comments on this comment yet.