Just anecdotal, but I find that mature pitaya, overall, can take as much water as you can give them - particularly from below provided they are not mostly shaded. Shallow roots systems can dry out up top, but mine are always wet 2 inches down and do fine. YMMV