If it's good enough, you'll find a place for it.
This is what we were told in undergraduate painting class by our professor, George Bogart.
We were 20 years old, living in small apartments with roommates, and painting 4-foot canvases. What on earth were we supposed to do with them? “If it's good enough, you'll find a place for it.”
Well, mine weren't good enough. I left them mostly unfinished–except for one–in the wall bins that lined the painting studios on campus. I never wanted to see those canvases again and only hope that some thrifty graduate student recovered them and painted over the undistinguished surfaces.
But yours probably are good enough.
Don't let size or space be an issue when you make your art. Make your art it as big as it needs to be in order to hold your ideas and dreams. If it's good enough, it will find a home. If you have to borrow a truck to haul it, you'll do that, too.
If it doesn't live up to your standards, destroy it, recycle it, or leave it for a grad student to find. Don't leave a sub-par work hanging around for your children to figure out what to do with.