4 ms·
The optimizer is smarter and it's better at concurrency control. You'll get better performance out of Oracle when you have very-long-running transactions or lo
by dfranke 19y ago
The optimizer is smarter and it's better at concurrency control. You'll get better performance out of Oracle when you have very-long-running transactions or lots of transactions at once operating on the same tables. The former isn't a concern for most web applications, but the latter might be.
The above is received wisdom from academics, though, so it may be dated. PostgreSQL has improved a lot in recent years.