Re:Scaling Databases at Activision [pdf]
by stickfigure on Saturday April 22, 2023 @12:46AM
(#35663409)
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".
* 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".