I agree with the commenters above that you probably need to provide context. In normal usage, something that is "tight" is too small or too narrow (so that something else does not fit easily or comfortably inside it). If your shoes are too tight, it will be painful to wear them. As a slang expression, "that's tight" means "that's cool," "that's awesome," "that's great," etc.

Thank you

This phrase could have have very different meanings (depending on the context), but the meaning that you are asking about is most likely slang. I think that this specific example sounds typical of the US in the 1990s. I'm not sure how common that this phrase is anymore, but it definitely isn't new slang. It essentially means "I like that" or "that is good."

I agree with Nanren888. Without context, the phrase means nothing whatsoever. You may as well look it up in the dictionary of your choice. Here's a good one for idiomatic expressions: https://www.thefreedictionary.com/tight

Any context? I managed to get the baby into the Jersey.. Gee, that's tight. Maybe we should let it breathe?