Feat: Fix thread contention during subgraph syncing #10344

Job	Run time
Subgraph Runner integration tests	2m 56s
Run unit tests	5m 42s
Run integration tests	3m 53s
Clippy linting	1m 15s
Check rustfmt style	27s
Build in release mode	3m 3s
	17m 16s

Provide feedback