The pH you get will depend upon the mineral content of your water and the types of malts you are using. In general, most base malts tend to produce a mash pH of around 5.5 to 5.6 on their own in distilled/deionized water. Darker malts will bring the pH down from that area.
The goal of the mash pH is to maximize the rate of enzyme activity. As long as your mash pH is between 5.2 and 5.8, you will be fine for enzyme activity. Most brewers target around 5.4 for mash pH as a general rule of thumb. The upper limit of a pH at 6.0 or above is critical as the combination of the high pH and temperatures above 170F/77C can leach harsh tannins from the grain husks which will result in a dry, astringent finish to your beer.