Remember that it's supposed to curve back towards the string. So long as it isn't curved the wrong way or even just flat you're probably not tightening it too far. Also don't loosen it too far. If the hairs aren't kept fairly flat they can tangle up a bit and you get a less constant tone or something. Other than that it's down to how flexible the bow is and how hard you press down on it when you play.