What is the effect of water pressure at the pipe joints?

Water constantly exerts pressure on pipe joints. I have seen old soldered joints flying apart when subjected to extreme pressure or trains passing nearby. This sometimes happens with plastic pipe also if joints are not thoroughly set .