Oracle 和 PostgreSQL 的性能差异有多大？

How big is the performance difference between Oracle and PostgreSQL?

提问by Ben Winters

I'm wondering about how to scale a database. Currently it uses PostgreSQL. Would switching to Oracle be worthwhile inspite of the coding pain and expense? Or is PostgreSQL + more boxes a better/cheaper approach?

我想知道如何扩展数据库。目前它使用 PostgreSQL。尽管编码的痛苦和费用，切换到 Oracle 是否值得？或者 PostgreSQL + 更多盒子是更好/更便宜的方法吗？

回答by Richard Harrison

IME there's not a lot between any of the major DBMS in terms of the performance that you can achieve by performance tuning. It's not just my experience Open Source PostgreSQL Trails Oracle In Benchmark, But Not By Much

IME 就您可以通过性能调优实现的性能而言，任何主要 DBMS 之间的差距并不大。这不仅仅是我的经验，开源 PostgreSQL 在基准测试中落后于 Oracle，但幅度不大

There is no substition for finding any performance problems and fixing them both in terms of client side and database optimisiation.

在客户端和数据库优化方面，无法找到任何性能问题并修复它们。

回答by Stradas

It wouldn't be an upgrade to go to Oracle. Just a migration. If you wish to upgrade Postgresql I strongly suggest you move to EnterpriseDB's Postgres Plus. They have created a Oracle compatible version of Postgres that will run all of the existing code, any new oracle centric code. Nearly all of the features anyone would buy oracle rdms for are in it. It is really fast too.

使用 Oracle 不会升级。只是迁移。如果您希望升级 Postgresql，我强烈建议您迁移到 EnterpriseDB 的 Postgres Plus。他们创建了一个 Oracle 兼容版本的 Postgres，它将运行所有现有代码，任何新的以 oracle 为中心的代码。几乎任何人都会购买 oracle rdms 的所有功能都在其中。它也很快。

If you are jealous of RAC, don't be. RAC is very expensive to maintain and is not real efficient per new box added. You can get the additional performance without the cost out of postgres. Look into PGPOOL as a solution for horizontal growth without the cost.

如果您嫉妒 RAC，请不要嫉妒。RAC 的维护成本非常高，而且每增加一个新的盒子就不是真正有效的。您可以在不花费 postgres 成本的情况下获得额外的性能。将 PGPOOL 视为一种无需成本的横向增长解决方案。

回答by Bob Jarvis - Reinstate Monica

I think that what you're suggesting is logically equivalent to Things You Should Never Do, Part I. This type of conversion is effectively a rewrite, and converting from one database to another (or one language to another, etc) is a great way to kill a lot of time and money that could otherwise be spent on actually improving your product. A better choice, as @Richard Harrison said above, would be to spend some time fixing whatever performance issues are driving you to consider moving to Oracle. As Fred Brooks said many years ago, there is No Silver Bullet.

我认为你的建议在逻辑上等同于你永远不应该做的事情，第一部分。这种类型的转换实际上是一种重写，从一种数据库转换到另一种（或将一种语言转换为另一种语言，等等）是一种很好的方式，可以节省大量时间和金钱，否则这些时间和金钱本可以花在实际改进产品上。正如上面@Richard Harrison 所说，更好的选择是花一些时间解决促使您考虑迁移到 Oracle 的任何性能问题。正如 Fred Brooks 多年前所说，没有银弹。

Share and enjoy.

分享和享受。

回答by a2j

I'll admit up front that I'm biased here, but I gotta tell you PostgreSQLis an amazing product! I'll admit I don't have any direct experience with Oracle, but everything I've ever read puts PostgreSQL within such a close range that even if it is a bit slower there is no question on my mind that spending any amount you could spend on licensing for Oracle instead on hardware or additional development time (to improve performance) should still leave you ahead in both dollars and performance.

我承认我在这里有偏见，但我得告诉你PostgreSQL是一个了不起的产品！我承认我对 Oracle 没有任何直接经验，但是我读过的所有内容都将 PostgreSQL 置于如此接近的范围内，即使它有点慢，我也毫无疑问可以花费任何金额花在 Oracle 许可上而不是在硬件上或额外的开发时间（以提高性能）应该仍然会让您在资金和性能方面领先。

Of course I do stipulate as others above have said that this is a question that really is too subjective unless we are going to talk about a particular situation or installed environment.

当然我确实像上面其他人所说的那样规定，这是一个过于主观的问题，除非我们要谈论特定情况或安装环境。