Re:Why Use Postgres?
by jbverschoor on Sunday April 30, 2017 @04:09PM
(#14233553)
Their own language prevents any kind of expensive queries.
Besides that, they limit the amount of anything you can think of (queries, cpu time, memory, call, querytime).
Killing connections can be done in postgresql too. The reason for sf to be on oracle is probably history.
Is that feature available in Microsoft SQL Server?
Re:Why Use Postgres?
by forgotpw1123 on Sunday April 30, 2017 @09:42PM
(#14234976)
Yes, there are resource controls in MS SQL server as well.
The best example of this is Salesforce, which has their own proprietary SQL-like query language that's clearly just a crappy front end to generate raw SQL to feed their Oracle DB's. Without Oracle's per-tenant limit this would be far too risky because of idiots making bad queries.
An better solution these days is to put each tenant in a Postgres container and let the OS control resource limits for them, but this wasn't an option until recently.