Oracle聽vs聽PostgreSQL

Need advice about which tool to choose?Ask the StackShare community!

Oracle

2.5K
1.7K
+ 1
113
PostgreSQL

93.7K
76.3K
+ 1
3.5K
Add tool

Oracle vs PostgreSQL: What are the differences?

Oracle and PostgreSQL are popular relational database management systems (RDBMS) known for their robust features and scalability. Here are the key differences between Oracle and PostgreSQL:

  1. Licensing and Cost: One of the primary differences between Oracle and PostgreSQL is the licensing and cost structure. Oracle is a commercial database and comes with a significant licensing cost, especially for enterprise-level deployments. In contrast, PostgreSQL is open-source and free to use, making it a more cost-effective choice for organizations with budget constraints or smaller-scale projects.

  2. Performance and Scalability: Oracle is known for its robust performance optimizations and advanced features like in-memory computing and real application clusters (RAC), which allow for horizontal scalability and high availability. PostgreSQL, on the other hand, offers excellent performance and scalability capabilities but may require additional configuration and optimization for specific use cases.

  3. Data Replication and High Availability: Oracle provides robust built-in replication and high availability features. These features enable real-time data replication and failover capabilities for ensuring high availability and disaster recovery. PostgreSQL also offers replication capabilities through streaming replication and logical replication, but it may require more configuration and setup compared to Oracle's comprehensive solutions.

  4. Ecosystem and Community: Oracle has a well-established ecosystem with a large community of users and extensive third-party tooling and support. It offers a wide range of integrated products, including middleware, analytics, and business intelligence tools. PostgreSQL has a vibrant and growing community, with a rich ecosystem of extensions and frameworks. While PostgreSQL's ecosystem is not as extensive as Oracle's, it is continuously expanding, and there are numerous tools and frameworks available for different use cases.

  5. SQL Compatibility: Oracle has its own SQL dialect, known as Oracle SQL, which includes proprietary features and extensions. PostgreSQL adheres more closely to the SQL standard and offers advanced SQL features like Common Table Expressions (CTEs) and window functions. Developers familiar with Oracle SQL may need to adjust their queries and code when migrating to PostgreSQL.

In summary, Oracle offers advanced features, scalability, and a comprehensive ecosystem but comes with a significant licensing cost. PostgreSQL, being open-source, provides cost-effectiveness, flexibility, and a growing community.

Decisions about Oracle and PostgreSQL
Micha Mail盲nder
CEO & Co-Founder at Dechea | 14 upvotes 路 68.2K views

Fauna is a serverless database where you store data as JSON. Also, you have build in a HTTP GraphQL interface with a full authentication & authorization layer. That means you can skip your Backend and call it directly from the Frontend. With the power, that you can write data transformation function within Fauna with her own language called FQL, we're getting a blazing fast application.

Also, Fauna takes care about scaling and backups (All data are sharded on three different locations on the globe). That means we can fully focus on writing business logic and don't have to worry anymore about infrastructure.

See more
Daniel Moya
Data Engineer at Dimensigon | 4 upvotes 路 389.8K views

We have chosen Tibero over Oracle because we want to offer a PL/SQL-as-a-Service that the users can deploy in any Cloud without concerns from our website at some standard cost. With Oracle Database, developers would have to worry about what they implement and the related costs of each feature but the licensing model from Tibero is just 1 price and we have all features included, so we don't have to worry and developers using our SQLaaS neither. PostgreSQL would be open source. We have chosen Tibero over Oracle because we want to offer a PL/SQL that you can deploy in any Cloud without concerns. PostgreSQL would be the open source option but we need to offer an SQLaaS with encryption and more enterprise features in the background and best value option we have found, it was Tibero Database for PL/SQL-based applications.

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Oracle
Pros of PostgreSQL
  • 44
    Reliable
  • 33
    Enterprise
  • 15
    High Availability
  • 5
    Expensive
  • 5
    Hard to maintain
  • 4
    Maintainable
  • 4
    Hard to use
  • 3
    High complexity
  • 759
    Relational database
  • 510
    High availability
  • 439
    Enterprise class database
  • 382
    Sql
  • 304
    Sql + nosql
  • 173
    Great community
  • 147
    Easy to setup
  • 131
    Heroku
  • 130
    Secure by default
  • 113
    Postgis
  • 50
    Supports Key-Value
  • 48
    Great JSON support
  • 34
    Cross platform
  • 32
    Extensible
  • 28
    Replication
  • 26
    Triggers
  • 23
    Rollback
  • 22
    Multiversion concurrency control
  • 21
    Open source
  • 18
    Heroku Add-on
  • 17
    Stable, Simple and Good Performance
  • 15
    Powerful
  • 13
    Lets be serious, what other SQL DB would you go for?
  • 11
    Good documentation
  • 8
    Reliable
  • 8
    Scalable
  • 8
    Intelligent optimizer
  • 7
    Modern
  • 7
    Transactional DDL
  • 7
    Free
  • 6
    One stop solution for all things sql no matter the os
  • 5
    Relational database with MVCC
  • 5
    Faster Development
  • 4
    Full-Text Search
  • 4
    Developer friendly
  • 3
    Free version
  • 3
    Great DB for Transactional system or Application
  • 3
    search
  • 3
    Open-source
  • 3
    Excellent source code
  • 3
    Relational datanbase
  • 2
    Full-text
  • 2
    Text

Sign up to add or upvote prosMake informed product decisions

Cons of Oracle
Cons of PostgreSQL
  • 14
    Expensive
  • 10
    Table/index bloatings

Sign up to add or upvote consMake informed product decisions

- No public GitHub repository available -

What is Oracle?

Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.

What is PostgreSQL?

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.

Need advice about which tool to choose?Ask the StackShare community!

What companies use Oracle?
What companies use PostgreSQL?
See which teams inside your own company are using Oracle or PostgreSQL.
Sign up for StackShare EnterpriseLearn More

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Oracle?
What tools integrate with PostgreSQL?

Sign up to get full access to all the tool integrationsMake informed product decisions

Blog Posts

Dec 8 2020 at 5:50PM

DigitalOcean

GitHubMySQLPostgreSQL+11
2
2300
Nov 20 2019 at 3:38AM

OneSignal

PostgreSQLRedisRuby+8
9
4542
Jul 9 2019 at 7:22PM

Blue Medora

DockerPostgreSQLNew Relic+8
11
2269
What are some alternatives to Oracle and PostgreSQL?
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
Workday
Workday is a leading provider of enterprise cloud applications for human resources and finance. Founded in 2005, Workday delivers human capital management, financial management, and analytics applications designed for the world鈥檚 largest organizations. Hundreds of companies, ranging from medium-sized businesses to Fortune 50 enterprises, have selected Workday.
Prophet
Prophet is a procedure for forecasting time series data. It is based on an additive model where non-linear trends are fit with yearly and weekly seasonality, plus holidays. It works best with daily periodicity data with at least one year of historical data. Prophet is robust to missing data, shifts in the trend, and large outliers.
IBM DB2
DB2 for Linux, UNIX, and Windows is optimized to deliver industry-leading performance across multiple workloads, while lowering administration, storage, development, and server costs.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
See all alternatives