In Shakespeare's time, mattresses were secured on bed frames by ropes. When you pulled on the ropes the mattress tightened, making the bed firmer to sleep on. That's how the phrase, "Good night, sleep tight" came about.

phrasemeaning.com