At a stated temperature, a saturated solution holds as much of a particular solute as it can dissolve at equilibrium. With more solute present, some remains undissolved.
Stirring, smaller grains and warming can speed up dissolution. The amount that can finally dissolve depends on the solute, solvent and conditions. Stirring alone does not change the equilibrium solubility.
Hard water contains appreciable dissolved calcium and magnesium ions. It can produce soap scum and can leave a mineral scale. Hardness can occur in clear water.