yeah, what he said ^^^ too much tension makes pedaling a bear, and you can almost never get the slack out all the way round anyway due to chainwheels being out of round or off center, and it leads to increased wear.
It does feel nice to trackstand with a really tight chain but it's not so nice to ride one.