How big is the performance difference between Oracle and PostgreSQL?

How big is the performance difference between Oracle and PostgreSQL?

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?

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

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

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.

Share and enjoy.

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.

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.

I'll admit up front that I'm biased here, but I gotta tell you PostgreSQL is 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.

물론 위의 다른 사람들이 특정 상황이나 설치된 환경에 대해 이야기하지 않는 한 이것은 정말로 너무 주관적인 질문이라고 말한 것처럼 규정합니다.

언급URL : https://stackoverflow.com/questions/3316812/how-big-is-the-performance-difference-between-oracle-and-postgresql