Improve pipe runtime memory allocation #29987

Job	Run time
unit-test (17, windows-latest, datanode)	10m 38s
unit-test (17, windows-latest, others)	10m 31s
unit-test (17, ubuntu-latest, datanode)	10m 27s
unit-test (17, ubuntu-latest, others)	10m 27s
	42m 3s

Provide feedback