Feat: Fix thread contention during subgraph syncing #10342

Job	Run time
Check rustfmt style	19s
Run unit tests	3m 36s
Run integration tests	2m 25s
Subgraph Runner integration tests	2m 11s
Clippy linting	2m 30s
Build in release mode	2m 12s
	13m 13s

Provide feedback