Feat: Fix thread contention during subgraph syncing #10338

Job	Run time
Run integration tests	7m 22s
Subgraph Runner integration tests	6m 9s
Run unit tests	6m 32s
Clippy linting	5m 6s
Build in release mode	4m 56s
Check rustfmt style	10s
	30m 15s

Provide feedback