PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality
Tags: postgres, oracle, database, infographic
Published: 2020-07-13 19:34:01

---
title: PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality
published: true
description: Compare Oracle vs. PostgreSQL database - see the differences in these SQL database costs, features, and ease of use for developers and DBA’s - ScaleGrid Blog
tags: PostgreSQL, Oracle, Database, Infographic,
//cover_image: https://scalegrid.io/blog/wp-content/uploads/2020/07/PostgreSQL-vs-Oracle-Difference-in-Costs-Ease-of-Use-and-Functionality-ScaleGrid-Blog.jpg
---
<link rel="canonical" href="https://scalegrid.io/blog/postgresql-vs-oracle-difference-in-costs-ease-of-use-functionality/" />
<p><a href="https://scalegrid.io/blog/postgresql-vs-oracle-difference-in-costs-ease-of-use-functionality/"><img class="alignnone size-full wp-image-5638" src="https://scalegrid.io/blog/wp-content/uploads/2020/07/PostgreSQL-vs-Oracle-Difference-in-Costs-Ease-of-Use-and-Functionality-ScaleGrid-Blog.jpg" alt="PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality - ScaleGrid Blog" width="100%" height="auto" /></a></p>
<p style="text-align: justify; padding-bottom: 10px;"><a style="color: #2da964;" href="https://www.oracle.com/database/" target="_blank">Oracle Database</a> is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. What’s causing this massive shift? The unstoppable <a style="color: #2da964;" href="https://db-engines.com/en/ranking_osvsc" target="_blank">rise of open source databases</a>. One database in particular is causing a huge dent in Oracle’s market share - open source <a style="color: #2da964;" href="https://www.postgresql.org/" target="_blank">PostgreSQL</a>. In this article, we compare <a href="https://scalegrid.io/blog/postgresql-vs-oracle-difference-in-costs-ease-of-use-functionality/">Oracle vs. PostgreSQL</a>, outlining the differences in these SQL database costs, features, and ease of use for both developers and database administrators (DBA’s) alike. Check out the <a style="color: #2da964; text-decoration: underline;" href="https://scalegrid.io/blog/postgresql-vs-oracle-difference-in-costs-ease-of-use-functionality/#4">PostgreSQL vs. Oracle Infographic</a>.</p>

<p style="text-align: justify; padding-top: 15px;">PostgreSQL is an open source object-relational database system with over 30 years of active development. Recognized as the <a style="color: #2da964;" href="https://db-engines.com/en/blog_post/79" target="_blank">fastest growing database</a> by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. In fact, PostgreSQL is so popular, 11.5% of PostgreSQL users are currently in the process of migrating to the RDBMS, according to the <a style="color: #2da964;" href="https://scalegrid.io/blog/2019-postgresql-trends-report-private-vs-public-cloud-migrations-database-combinations-top-reasons-used/" target="_blank">2019 PostgreSQL Trends Report</a>, an astounding percentage considering this is the 4th most popular database in the world. The report also analyzes the most popular database combinations with PostgreSQL, where 27.3% are currently leveraging Oracle Database within the same organization. This is largely attributed to the shift from commercial to open source, where organizations will develop new applications using an open source database while their legacy systems still remain on Oracle. These new applications are a great way for enterprise companies to test out PostgreSQL before migrating their entire infrastructure.</p>
<p style="text-align: justify;">Now that we’ve covered the current state of affairs of our two databases, let’s compare the different features, ease of use, and costs of PostgreSQL vs. Oracle:</p>

<h2 style="padding-top: 15px;"><a id="1"></a>PostgreSQL vs. Oracle Costs</h2>
<p style="text-align: justify;">The <a style="color: #2da964;" href="https://scalegrid.io/blog/2019-postgresql-trends-report-private-vs-public-cloud-migrations-database-combinations-top-reasons-used/" target="_blank">#1 reason why PostgreSQL is used over another RDBMS</a> is because of costs. The free open-source database is a great alternative to Oracle as it has no licensing costs, saving DBA’s and developers time right off the bat as they do not have to sit through lengthy licensing discussions and negotiations. You can find basically everything you need in the free community version, and any other requirements can be found in one of the hundreds of extensions developed by the community. Oracle, however, breaks down a lot of their features into separate licenses so you have to pay for those extra capabilities, and many of the advanced features are <a style="color: #2da964;" href="https://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm#DBLIC118" target="_blank">only available in their Enterprise Edition</a>, such as rolling upgrades, advanced security, advanced replication and partitioning.</p>
<p style="text-align: justify; padding-bottom: 20px;">In this breakdown, we are only going to compare some key licensing and support costs between PostgreSQL and Oracle, as Oracle offers dozens of add-on features for extra costs. You can compare all of their license costs in their <a style="color: #2da964;" href="https://www.oracle.com/assets/technology-price-list-070617.pdf" target="_blank">Oracle Technology Global Price List</a>.</p>

<table width="100%">
<tbody>
<tr>
<th width="28%"></th>
<th style="background-color: #336791; padding: 10px; color: #fff;" width="24%"><b>PostgreSQL Community</b></th>
<th style="background-color: #e20010; padding: 10px; color: #fff;" width="24%"><b><b>Oracle Standard Edition</b></b></th>
<th style="background-color: #950f18; padding: 10px; color: #fff;" width="24%"><b><b>Oracle Enterprise Edition</b></b></th>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;">Single Database Edition Costs</td>
<td style="border: 1px solid #eee; padding: 10px;">$0</td>
<td style="border: 1px solid #eee; padding: 10px;">$17,500</td>
<td style="border: 1px solid #eee; padding: 10px;">$47,500</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;">Clustering / Replication</td>
<td style="border: 1px solid #eee; padding: 10px;">$0</td>
<td style="border: 1px solid #eee; padding: 10px;">Not available</td>
<td style="border: 1px solid #eee; padding: 10px;">$23,000</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;">Advanced Security</td>
<td style="border: 1px solid #eee; padding: 10px;">$0</td>
<td style="border: 1px solid #eee; padding: 10px;">Not available</td>
<td style="border: 1px solid #eee; padding: 10px;">$15,000</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;">Software Update License &amp; Support (annual)</td>
<td style="border: 1px solid #eee; padding: 10px;">$0</td>
<td style="border: 1px solid #eee; padding: 10px;">Not available</td>
<td style="border: 1px solid #eee; padding: 10px;">$18,810</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Total Cost</b></td>
<td style="border: 1px solid #eee; padding: 10px;"><b>$0</b></td>
<td style="border: 1px solid #eee; padding: 10px;"><b>$17,500</b></td>
<td style="border: 1px solid #eee; padding: 10px;"><b>$104,310</b></td>
</tr>
</tbody>
</table>
<p style="text-align: justify; padding-top: 20px;">The $47,500 licensing costs for Oracle Enterprise Edition is only for one CPU core, that ultimately has to be multiplied with the actual number of cores on the physical server. Oracle does offer discounts on their pricing, where you can receive a 10% discount if you purchase online. There is also a wide network of <a style="color: #2da964;" href="https://theguardianeagle.com/oracle-software-discounts/" target="_blank">Oracle partners available to help you negotiate a discount</a>, typically ranging from 15%-30%, though larger discounts of up to 40%-60% are available for larger accounts.</p>

<h2 style="padding-top: 15px;"><a id="2"></a>PostgreSQL vs. Oracle Functionality</h2>
<p style="text-align: justify;">PostgreSQL functionality continues to evolve with the variety of tools and consultants available through the open source community, making it on par with nearly all aspects of Oracle Database with none of the cost. Oracle requires more complex ongoing administration, as all database configurations must evolve in conjunction with the data schemas and custom code. The extreme complexity also increases the risk of error which can lead to critical mistakes that cost more time and money to resolve, which is why it is a common best practice in Oracle to limit changes to only a couple times each year.</p>

<h3 style="padding-top: 15px; padding-bottom: 10px;">Comparison Overview</h3>
<p style="text-align: justify; padding-bottom: 20px;">Let's take a look at core functionality of these two relational database management systems.</p>

<table width="100%">
<tbody>
<tr>
<th width="20%"></th>
<th style="background-color: #336791; padding: 10px; color: #fff;" width="40%"><b>PostgreSQL</b></th>
<th style="background-color: #e20010; padding: 10px; color: #fff;" width="40%"><b>Oracle</b></th>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Scalability</b></td>
<td style="border: 1px solid #eee; padding: 10px;">PostgreSQL offers free scalability, and can scale up to <a style="color: #2da964;" href="https://www.cybertec-postgresql.com/en/services/administration/postgresql-performance-and-scalability/" target="_blank">millions of transactions per seconds</a>.</td>
<td style="border: 1px solid #eee; padding: 10px;">Oracle Enterprise is recommended for high workloads which are highly scalable, but costly.</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Updates</b></td>
<td style="border: 1px solid #eee; padding: 10px;">Since the last few years, new major <a style="color: #2da964;" href="https://www.postgresql.org/support/versioning/" target="_blank">PostgreSQL versions</a> are released every year and minor versions with bug fixes are released every 3 months. One of the best things about Postgres is that the PostgreSQL Global Development Group announces the major and minor release dates <a style="color: #2da964;" href="https://www.postgresql.org/developer/roadmap/" target="_blank">in advance</a> for the convenience of users and prospects.</td>
<td style="border: 1px solid #eee; padding: 10px;">New Oracle <a style="color: #2da964;" href="https://support.oracle.com/knowledge/Oracle%20Database%20Products/742060_1.html" target="_blank">versions</a> are generally available every 2-4 years.</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Security</b></td>
<td style="border: 1px solid #eee; padding: 10px;">PostgreSQL offers <a style="color: #2da964;" href="https://www.highgo.ca/2020/01/22/understanding-security-features-in-postgresql-part-1/" target="_blank">strong security capabilities</a> through different authentication options (Host, LDAP, PAM and certificates authentication) and role-based access control (user-level, table-level and row-level). Data encryption can be achieved with advanced security plugins like <a style="color: #2da964;" href="https://www.postgresql.org/docs/current/pgcrypto.html" target="_blank">pgcrypto</a> which are available for free.</td>
<td style="border: 1px solid #eee; padding: 10px;">Oracle offers advanced security packages, but as a commercial database, they are available as an <a style="color: #2da964;" href="https://www.oracle.com/assets/technology-price-list-070617.pdf" target="_blank">expensive add-on</a>.</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Replication</b></td>
<td style="border: 1px solid #eee; padding: 10px;">PostgreSQL supports native <a style="color: #2da964;" href="https://www.postgresql.org/docs/9.2/runtime-config-replication.html" target="_blank">streaming replication</a> and <a style="color: #2da964;" href="https://www.postgresql.org/docs/12/logical-replication.html" target="_blank">logical replication</a>.</td>
<td style="border: 1px solid #eee; padding: 10px;">Oracle supported master-slave and master-master replication via Oracle Streams and Oracle multi-master in the older versions of Oracle Enterprise Edition, which has now been replaced by <a style="color: #2da964;" href="https://www.oracle.com/middleware/technologies/goldengate.html" target="_blank">Oracle GoldenGate</a> (a separately licensed application) for all types of data replications.</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Partitioning</b></td>
<td style="border: 1px solid #eee; padding: 10px;">PostgreSQL supports <a style="color: #2da964;" href="https://www.postgresql.org/docs/10/ddl-partitioning.html" target="_blank">declarative partitioning</a>.</td>
<td style="border: 1px solid #eee; padding: 10px;">Oracle supports general <a style="color: #2da964;" href="http://www.dba-oracle.com/tp_Oracle_warehouse_horizontal_partitioning.htm" target="_blank">horizontal partitioning</a> supported by all RDBMS.</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Cloud Deployments</b></td>
<td style="border: 1px solid #eee; padding: 10px;">Can be deployed on any cloud provider, with a variety of <a style="color: #2da964;" href="https://scalegrid.io/postgresql.html" target="_blank">PostgreSQL hosting</a> solutions available.</td>
<td style="border: 1px solid #eee; padding: 10px;">Can only be deployed on Oracle Cloud and other popular cloud providers, but users must <a style="color: #2da964;" href="https://oracle-base.com/articles/misc/oracle-databases-in-the-cloud" target="_blank">Bring Your Own License (BYOL) or use on-demand licensing</a>.</td>
</tr>
</tbody>
</table>
<p style="text-align: justify; padding-top: 20px;">PostgreSQL also introduced many other breakthrough features starting in version 10 through 11 and 12 that make it a real competitor against Oracle, such as partitioning enhancements, parallel query and logical replication. We'll be covering these in an up-coming post where you can learn more about PostgreSQL’s competitive advantages when it comes to these new features.</p>

<h2 style="padding-top: 15px;"><a id="3"></a>PostgreSQL vs. Oracle Ease of Use</h2>
<p style="text-align: justify; padding-bottom: 20px;">PostgreSQL community is one of the most active open source communities. There are a wide range of tools and extensions for every conceivable scenario, like performance profiling, auditing, etc. This reduces the amount of time development teams need to put together custom tooling to address their scenarios. Oracle also offers many tools, but they are all available as add-on solutions with additional processor license and software update license costs and support fees. Postgres experts and consultants are widely available at more reasonable rates than Oracle services. Free support for PostgreSQL is also available through many local PostgreSQL user groups all over the world, and there is also an active IRC and Slack community.</p>

<table width="100%">
<tbody>
<tr>
<th width="20%"></th>
<th style="background-color: #336791; padding: 10px; color: #fff;" width="40%"><b>PostgreSQL</b></th>
<th style="background-color: #e20010; padding: 10px; color: #fff;" width="40%"><b>Oracle</b></th>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Compatibility</b></td>
<td style="border: 1px solid #eee; padding: 10px;">PostgreSQL PL/pgsql is compatible with other relational databases like Oracle which makes it relatively easy to move to PostgreSQL.</td>
<td style="border: 1px solid #eee; padding: 10px;">Oracle infrastructure does not offer strong compatibility with open source RDBMS.</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Extensions</b></td>
<td style="border: 1px solid #eee; padding: 10px;">PostgreSQL offers many free open-source extensions, including:</br></br><b>PostGIS</b> - support for geospatial objects store and query.

<b>CitusDB</b> - distributes data and queries horizontally across nodes.

<b>pg_repack</b> - reorganizes tables online to reclaim storage.</td>
<td style="border: 1px solid #eee; padding: 10px;">Oracle offers commercial add-ons that are available for an additional <a style="color: #2da964;" href="https://www.oracle.com/assets/technology-price-list-070617.pdf" target="_blank">license fee</a>.</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Tuning</b></td>
<td style="border: 1px solid #eee; padding: 10px;">PostgreSQL offers more light-weight tuning capabilities, like their Query Optimizer, and DBaaS platforms like <a style="color: #2da964;" href="https://scalegrid.io/postgresql.html" target="_blank">ScaleGrid</a> offer advanced slow query analysis.</td>
<td style="border: 1px solid #eee; padding: 10px;">Oracle requires significantly more effort to install and configure due to the hundreds of tuning variables and complex system requirements. Most of the tuning capabilities provided from Automatic Workload Repository (AWR) and database advisers comes bundled with Oracle Enterprise Manager Database/Grid control that requires the Enterprise Edition.</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Supported Operating Systems</b></td>
<td style="border: 1px solid #eee; padding: 10px;">
<ul>
	<li>AIX</li>
	<li>HP-UX</li>
	<li>Linux</li>
	<li>OS X</li>
	<li>Solaris</li>
	<li>Windows</li>
	<li>z/OS</li>
</ul>
</td>
<td style="border: 1px solid #eee; padding: 10px;">
<ul>
	<li>FreeBSD</li>
	<li>HP-UX</li>
	<li>Linux</li>
	<li>NetBSD</li>
	<li>OpenBSD</li>
	<li>OS X</li>
	<li>SolarisUnix</li>
	<li>Windows</li>
</ul>
</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Supported Languages</b></td>
<td style="border: 1px solid #eee; padding: 10px;">
<ul>
	<li>C</li>
	<li>C#</li>
	<li>C++</li>
	<li>Clojure</li>
	<li>Cobol</li>
	<li>Delphi</li>
	<li>Eiffel</li>
	<li>Erlang</li>
	<li>Fortran</li>
	<li>Groovy</li>
	<li>Haskell</li>
	<li>Java</li>
	<li>JavaScript</li>
	<li>Lisp</li>
	<li>Objective C</li>
	<li>OCaml</li>
	<li>Perl</li>
	<li>PHP</li>
	<li>Python</li>
	<li>R</li>
	<li>Ruby</li>
	<li>Scala</li>
	<li>Tcl</li>
	<li>Visual Basic</li>
</ul>
</td>
<td style="border: 1px solid #eee; padding: 10px;">
<ul>
	<li>.Net</li>
	<li>C</li>
	<li>C++</li>
	<li>Delphi</li>
	<li>Java</li>
	<li>JavaScript (Node.js)</li>
	<li>Perl</li>
	<li>PHP</li>
	<li>Python</li>
	<li>Tcl</li>
</ul>
</td>
</tr>
<tr>
<td style="border: 1px solid #eee; padding: 10px; background: #f9f9f9;"><b>Support</b></td>
<td style="border: 1px solid #eee; padding: 10px;">PostgreSQL support is available free from the community, and there are also many support providers available for advanced assistance.</td>
<td style="border: 1px solid #eee; padding: 10px;">Oracle support for hardware and software packages is typically available at <a style="color: #2da964;" href="https://www.oracle.com/assets/technology-price-list-070617.pdf" target="_blank">22% of their licensing fees</a>.</td>
</tr>
</tbody>
</table>
<h2 style="padding-top: 20px;">So Which Is Best?</h2>
<p style="text-align: justify;">PostgreSQL is without a doubt a powerful alternative to Oracle, and keeps getting better with every minor and major upgrade. Many organizations leveraging Oracle today are strategizing their migration to PostgreSQL to escape the high cost of service and vendor lock-in, and there are dozens of organizations out there to assist with a managed migration. If you’re wondering whether it’s right for you, take a look at some of the stories from these enterprise brands that have made the switch, including the <a style="color: #2da964;" href="https://www.enterprisedb.com/news/us-government-agencies-turn-enterprisedb-and-postgres-slash-database-costs-80" target="_blank">Federal Aviation Authority</a> (FAA), <a style="color: #2da964;" href="https://www.techrepublic.com/article/oracles-biggest-database-foe-could-it-be-postgres/" target="_blank">Goldman Sachs</a>, and <a style="color: #2da964;" href="https://www.infoworld.com/article/3261571/how-postgresql-just-might-replace-your-oracle-database.html" target="_blank">Salesforce</a>.</p>
<p style="text-align: justify;">Want a deeper look into the total cost of ownership of PostgreSQL vs. Oracle? Download our TCO to compare costs of both a small and large enterprise deployment with these two SQL databases to see how you can save up to 69% on your total costs over 3 years: visit the <a href="https://scalegrid.io/blog/postgresql-vs-oracle-difference-in-costs-ease-of-use-functionality/">original post</a> to download and read.</p>

<p style="text-align: justify; padding:25px 0px;"><a id="4"></a><a href="https://scalegrid.io/blog/postgresql-vs-oracle-difference-in-costs-ease-of-use-functionality/"><img class="alignnone size-full wp-image-5638" src="https://scalegrid.io/blog/wp-content/uploads/2020/07/PostgreSQL-vs-Oracle-Database-Infographic-ScaleGrid-Blog.jpg" alt="PostgreSQL vs Oracle Database Infographic: Compare Costs, Functionality and Ease of Use - ScaleGrid Blog" width="100%" height="100%" /></a></p>