alt Hacker NewsThe thing that usually pushes you off Postgres is rarely raw throughput, it's two workloads that want opposite tuning on the same box.
The thing that usually pushes you off Postgres is rarely raw throughput, it's two workloads that want opposite tuning on the same box.
The solution might be to move to separate Postgres boxes everything that needs performance tuning at all.
I'm not in the "use Postgres for everything" camp, but only because I think it's too complex to be used like that. It should be replaced with a bunch of simple primitives in this role. No SQL and query planning magic please.