Improving query performance in ElasticSearch at scale

If R = 1 and W = N, we optimize for fast read. If W = 1 and R = N, we optimize for fast write. Durability is not guaranteed in the presence of failures.

Eventually their database became a ticking time bomb ready to explode at any moment. The first instinct might be to beef up their Postgres instance, like me trying to get big at the gym. But there are physical limits to how much you can scale a single machine before costs increase exponentially. Moreover, query performance and maintenance processes