Foam or Regular Mattress for Loft Bedroom?

Our new tiny house has a loft bedroom, with a typically low ceiling.  So, we will put a 6-8" mattress up there.  I'm debating between a memory foam mattress or a regular one.  I found an 8" regular one on Amazon with lots of good reviews and the memory foam mattresses have good reviews, too.  A regular one would be a lot more work to get up into the loft, and it's more expensive.  Any thoughts on whether it makes a significant difference as to which of these you choose?