There are a wide range of hospital mattresses.
The basic ones do little to prevent. Then there are the air mattresses where the pt is sleeping on a cushion of air. This works much better. Really the best help is frequent changing of position to prevent prolonged pressure on one spot for more than 1. - -2 hours