A tri suit or a wet suit?

If you're talking about a wet suit, yes it should be quite tight. I've seen many people with a zipper-pull extension so they can zip and unzip it themselves more easily.

Regarding the tri suit... Yes it should be tight too. But I'm not sure about the zipper thing!!