Improve pipe runtime memory allocation #29883

Job	Run time
unit-test (17, windows-latest, datanode)	33m 36s
unit-test (17, ubuntu-latest, others)	19m 37s
unit-test (17, windows-latest, others)	28m 38s
unit-test (17, ubuntu-latest, datanode)	22m 37s
	1h 44m 28s

Provide feedback