Feat: Fix thread contention during subgraph syncing #10352

Job	Run time
Run unit tests	5m 26s
Subgraph Runner integration tests	1m 41s
Run integration tests	3m 47s
Clippy linting	1m 12s
Check rustfmt style	17s
Build in release mode	2m 22s
	14m 45s

Provide feedback