CodeChain-io / CodeChain-io/codechain-indexer
Use cluster for blocks and transactions
- Dominant language
- TypeScript
- Stars
- 21
- Forks
- 15
- PR merge metrics
- No merged PRs in 30d
Description
The records may be inserted in the order of the block number and many API returns the result in order of the block number.
In these cases, using cluster can make the insertion and reading fast.
https://www.postgresql.org/docs/9.1/sql-cluster.html
Contributor guide
No contributing guide indexed for this repository
Research direction
No files or tests are identified in the issue. Start by locating the block and transaction tables and the queries that return records by block number, then review PostgreSQL CLUSTER behavior and its operational requirements. Done means the relevant tables use clustering where appropriate and insertion and block-number-ordered reads are verified to improve.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, typescript
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100