How Tight Should Climbing Shoes Be?

It’s tempting to fit your shoes too tight, but easy to size them too large. Advice for getting it just right.