| ▲ | valentynkit 2 hours ago | |||||||
The thing that usually pushes you off Postgres is rarely raw throughput, it's two workloads that want opposite tuning on the same box. | ||||||||
| ▲ | Kinrany 2 hours ago | parent [-] | |||||||
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. | ||||||||
| ||||||||