Yes Mr Musk. It depends on the size of the overall....

rather than the height however, length,

since the pump will require more power to shoot up the water up again.

 

maximize length, maximize gain from gravity,

and minimize energy required for the pump....

if it's a low energy requirement for the pump then...

i guess the height is viable also....