Feat: Fix thread contention during subgraph syncing #10337

Job	Run time
Subgraph Runner integration tests	2m 51s
Run integration tests	3m 52s
Check rustfmt style	27s
Run unit tests	5m 33s
Build in release mode	2m 46s
Clippy linting	2m 7s
	17m 36s

Provide feedback