Believe it or not, a well-controlled clinical was conducted on this topic. Turns out, contrary to popular opinion, a medium-firm mattress is best for those with back pain.
lancet study on mattress firmness
lancet study on mattress firmness