Feat: Fix thread contention during subgraph syncing #10356

Job	Run time
Subgraph Runner integration tests	1m 33s
Run unit tests	1m 34s
Run integration tests	1m 33s
Check rustfmt style	13s
Build in release mode	1m 27s
Clippy linting	1m 38s
	7m 58s

Provide feedback