Bill, It's impossibe to predict what your recovery will be like, but the answers provided so far offer a range of experiences.
As for my experience, I didn't use a bucket, just placed the large bag on the floor next to the bed, and slept like a baby, with no pain. I went into the hospital weighing exactly 200 pounds and came home weighing 220 (lots of IV fluids). The first night, I nearly filled the large bag and lost a little more than 5 pounds.
I had surgery on a Friday, but stayed in the hospital until Monday morning because I had some bowel adhesions that the uro repaired during the prostate surgery. We live just 20 miles from the hospital, but the drive home seemed longer. Tuesday morning, I walked up and down the block and then went to our favorite restaurant for breakfast with my wife and my youngest brother. On Thursday of that week, we went to the funeral home for a wake, and no one was aware of the hip bag under my loose suit trousers.
I was really grateful for that small leg bag and switched back and forth, using it during the day and the large bag at night, no problem. It was late August and early September, and my wife and I walked at least a mile every day, with me wearing the leg bag underneath baggy basketball shorts. The walks were mostly on bike paths, so the fact that the bag was a bit visible belowthe shorts wasn't really an issue. In fact, I walked a mile in the hospital on Saturday and again on Sunday.
I didn't use much pain medication in the hospital, and none after getting home, though I did have a brief issue with bladder spasms. Even though I was catheterized, I felt as if I had an urgent need to urinate, and then I could feel myself urinating, which was very odd, since with the catheter the bladder never really fills. The uro ordered some medication that stopped the spasms right away.
One big mistake I made was trying to rush the first bowel movement. I was mistakenly under the impression that I wouldn't be discharged from the hospital until I had a BM. As a result, I strained way too hard. Not a good idea.
The worst part of the whole experience was the gas pains during the hospital stay. My uro ordered simethicone, which helped, but the stupid nursing staff didn't tell me it was a standing order and that I could have, and should have, had it every four or six hours. This was a bad oversight on the part of the nursing staff, and it earned vocal criticism from my own R. N. wife.
Good luck to you, and I hope your experience is as problem free as mine was. Be sure to let us know how it goes.