Feat: Fix thread contention during subgraph syncing #10335

Job	Run time
Run integration tests	3m 46s
Subgraph Runner integration tests	2m 50s
Check rustfmt style	20s
Run unit tests	5m 23s
Build in release mode	1m 21s
Clippy linting	1m 18s
	14m 58s

Provide feedback