> You do need to understand your access patterns well,

I've found that being able to change quickly is more valuable that the marginal performance boost that mongo would give. Denormalization is possible in postgres.

Where have you seen this trade off go well?