Paweł Pierścionek
Paweł Pierścionek
## Problem There are use cases where one needs algod/indexer client to dial a different IP than the one resolved from hostname (aka fake hostname) This should be possible by...
## Problem All indexer indices are btree but not all have to be. ## Solution Replace btree indexes with hash indexes in places where only exact searches are used and...
## Problem The largest index currently is txn_participation_i sitting @ almost 90GB while base table is only 60GB. Smaller indexes are generally faster for writing and there are more possibilities...
## Problem Any usage of custom headers in HTTP requests causes browsers to send extra preflight query. This makes no sense in case of empty token and can be avoided...
## Problem We've deployed 2.14.0rc3 on testnet on 25+ nodes. After two days of testing (that includes random restarts) we've observed ledger cache ahead of postgres ledger which requires manual...
## Problem Next token is ignored in some CTEs causing full table scans during pagination. ## Solution This patch shows x5 speedup in average query exec time. Not an ultimate...
## Problem Queries with after/before-time have unpredictable performance due to Postgres optimizer issues with joins with block_header table. Postgres 14 appears to create even worse performing query plans then PG13...
## Status Currently node stores a few deltas in memory only. ## Expected Node optionally stores deltas along with blocks and allows for retrieval from storage. This could be available...
## Status IncomingConnectionsLimit param is designed to limit longed lived connections (websocket) only. With the current implementation is rejects requests for catchups and blocks on gossip port. Also makes it...
Algorand NC support using public API from Nodely.io.