I have a Nikon D5000 I use professionally. It's not the kind of camera I want to haul around for everyday use so I purchased a Sony Cyber-shot that I can slip into a pocket or my purse. However, this little camera takes up to 12 MB shots!
If I'm in a hurry and don't change my settings, I have some really large files!
Most of the time, I don't need my files to be high resolution since they are intended for viewing on a computer screen and not for print.
The good news is you don't need an expensive program like Photoshop to resize images. I've found a free program that will even resize batches of files in a few seconds.
It's called Photosizer.
Check it out at http://www.fotosizer.com/