Feat: Fix thread contention during subgraph syncing #10365

Job	Run time
Subgraph Runner integration tests	1m 44s
Clippy linting	2m 59s
Check rustfmt style	17s
Build in release mode	2m 34s
Run integration tests	3m 46s
Run unit tests	5m 27s
	16m 47s

Provide feedback