Either an Insult or Compliment depending on the tone of voice in which the verbal linguist chooses, it can mean, Dickish, Tight, etc

the whale tail is the shape formed when a g-string rides up high over a womans trousers