Looking back over my ~30 yr career I could pretty neatly divide my projects into two categories: * Low volume, complicated queries * High volume, simple queri

Looking back over my ~30 yr career I could pretty neatly divide my projects into two categories: * Low volume, complicated queries * High volume, simple queries In the rare case that I've seen high volume, complicated queries it generally involves a lot of pre-indexing, denormalization, and exotic data structures. Postgres really shines in the first case, which is probably the dominant case for "data important enough to pay people to work on".