midnightntwrk / midnightntwrk/midnight-node-docker
Optimise postgres
Open
Nobody has claimed this yet.
good first issue
midnight-node-docker
public
TRIAGE
- Dominant language
- Shell
- Stars
- 34
- Forks
- 21
- PR merge metrics
- No merged PRs in 30d
Description
Describe the proposed feature:
We should investigate optimising postgres params using https://pgtune.leopard.in.ua/
Expected Benefit:
Faster sync times
Details:
It's been suggested that potentially a 2x improvement in cardano db-sync sync speed can be achieved.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the pgtune link and the PostgreSQL parameters relevant to Cardano db-sync. Measure current sync times, compare the suggested tuning, and validate whether the resulting configuration improves sync speed; done means documenting the tested settings and measured benefit.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgres
- Domain
- databases, performance
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100