You didn't say what tire you're talking about - they're all different. The PSI range is printed right on the side of the tire, so start there. It has nothing to do with your weight and everything to do with the tires themselves.

Generally, higher pressure gives you less rolling resistance while lower pressure gives you a cushier ride and better grip on some surfaces. Just experiment within the range printed on the side of the tire and you'll be fine.