Weed and Sex?

Sooo I'm planning on doing my first time and my soon to be sex partner recommended for us to smoke some weed...he said that I'll feel more with it and makes sex a lot better and I won't feel the pain as much. Anyone have experience with weed and sex? Was it worth it? What's the pros and cons?