A good rule is a half inch of sag... a too tight chain will slow you down by putting a lot of stress on your drive train as the chain will try and pull the chain ring and cog closer together... this is what happens when a chain binds.

You don't want that.