Introducing G2.ai, the future of software buying.Try now

Compare Oracle Database and PostgreSQL

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Oracle Database
Oracle Database
Star Rating
(988)4.3 out of 5
Market Segments
Enterprise (60.9% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Oracle Database
PostgreSQL
PostgreSQL
Star Rating
(663)4.4 out of 5
Market Segments
Small-Business (35.9% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about PostgreSQL
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that PostgreSQL excels in ease of use with a score of 8.5 compared to Oracle Database's 8.3. Reviewers mention that PostgreSQL's intuitive interface and comprehensive documentation make it easier for new users to get started.
  • Reviewers mention that PostgreSQL has a slight edge in data types with a score of 9.2 versus Oracle's 8.9. Users appreciate PostgreSQL's support for a wider variety of data types, including JSONB, which enhances flexibility in data modeling.
  • G2 users highlight PostgreSQL's superior query language capabilities, scoring 9.1 compared to Oracle's 8.9. Reviewers say that PostgreSQL's advanced features, such as Common Table Expressions (CTEs) and window functions, provide more powerful querying options.
  • Users on G2 report that both databases have similar disaster recovery capabilities, each scoring 8.6. However, reviewers mention that Oracle Database's built-in features like Data Guard offer more robust options for enterprise-level recovery scenarios.
  • Reviewers mention that PostgreSQL shines in data replication with a score of 8.9, slightly ahead of Oracle's 8.8. Users appreciate PostgreSQL's logical replication feature, which allows for more flexible data distribution across different systems.
  • Users say that Oracle Database is favored for its strong security features, scoring 9.0 compared to PostgreSQL's 8.7. Reviewers highlight Oracle's advanced encryption and access control mechanisms as critical for enterprise security needs.
Pricing
Entry-Level Pricing
Oracle Database
No pricing available
PostgreSQL
No pricing available
Free Trial
Oracle Database
No trial information available
PostgreSQL
No trial information available
Ratings
Meets Requirements
9.0
709
9.1
543
Ease of Use
8.3
715
8.5
548
Ease of Setup
7.6
372
8.4
277
Ease of Admin
7.8
327
8.2
249
Quality of Support
8.3
679
7.9
439
Has the product been a good partner in doing business?
8.1
329
8.4
198
Product Direction (% positive)
8.2
678
8.5
530
Features by Category
8.8
560
8.9
505
Management
9.0
143
9.1
121
8.9
145
9.1
119
8.9
128
9.1
107
8.8
138
8.9
110
Support
8.4
140
8.6
113
8.9
143
9.2
123
8.7
141
9.1
110
8.8
139
9.1
112
Security
8.8
141
8.7
114
8.8
143
8.9
116
8.7
136
8.6
108
8.8
142
8.9
110
Performance
8.6
138
8.6
106
8.8
137
8.8
112
8.5
137
8.6
106
8.8
140
8.8
111
8.8
144
8.6
109
Database Features
9.0
494
9.0
460
9.0
496
9.0
465
8.9
501
9.0
468
8.7
493
8.6
450
9.0
493
8.7
439
8.8
486
8.8
453
8.9
495
9.0
460
Database as a Service (DBaaS)Hide 17 FeaturesShow 17 Features
8.7
95
Not enough data
Configuration
8.7
91
Not enough data
8.3
87
Not enough data
8.6
89
Not enough data
8.4
84
Not enough data
8.9
88
Not enough data
Database Administration
8.5
85
Not enough data
8.8
83
Not enough data
8.9
85
Not enough data
Availability
8.9
87
Not enough data
9.0
89
Not enough data
8.8
83
Not enough data
8.7
84
Not enough data
Security
8.8
86
Not enough data
8.6
83
Not enough data
8.7
80
Not enough data
Data Management
8.9
81
Not enough data
8.7
80
Not enough data
Categories
Categories
Shared Categories
Oracle Database
Oracle Database
PostgreSQL
PostgreSQL
Oracle Database and PostgreSQL are categorized as Relational Databases
Unique Categories
Oracle Database
Oracle Database is categorized as Database as a Service (DBaaS)
PostgreSQL
PostgreSQL has no unique categories
Reviews
Reviewers' Company Size
Oracle Database
Oracle Database
Small-Business(50 or fewer emp.)
11.9%
Mid-Market(51-1000 emp.)
27.1%
Enterprise(> 1000 emp.)
60.9%
PostgreSQL
PostgreSQL
Small-Business(50 or fewer emp.)
35.9%
Mid-Market(51-1000 emp.)
33.8%
Enterprise(> 1000 emp.)
30.3%
Reviewers' Industry
Oracle Database
Oracle Database
Information Technology and Services
20.6%
Computer Software
11.5%
Financial Services
5.6%
Banking
5.1%
Hospital & Health Care
4.3%
Other
52.9%
PostgreSQL
PostgreSQL
Information Technology and Services
27.3%
Computer Software
23.1%
Internet
4.3%
Financial Services
4.1%
Telecommunications
2.9%
Other
38.3%
Alternatives
Oracle Database
Oracle Database Alternatives
Amazon Relational Database Service (RDS)
Amazon Relational Database Service (RDS)
Add Amazon Relational Database Service (RDS)
IBM Db2
IBM Db2
Add IBM Db2
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Amazon Aurora
Amazon Aurora
Add Amazon Aurora
PostgreSQL
PostgreSQL Alternatives
Microsoft SQL Server
MS SQL
Add Microsoft SQL Server
MySQL
MySQL
Add MySQL
Amazon Relational Database Service (RDS)
Amazon Relational Database Service (RDS)
Add Amazon Relational Database Service (RDS)
IBM Db2
IBM Db2
Add IBM Db2
Discussions
Oracle Database
Oracle Database Discussions
What is Oracle Database used for?
2 Comments
Abid Hussain A.
AA
Oracle Database is a relational database management system (RDBMS) that is widely used in the industry for managing and storing large volumes of data. It...Read more
What is the solution for extracting pdf data stored in DB in clob format
1 Comment
walter g.
WG
try APEXRead more
Why oracles was not up the mark in mobile arena.
1 Comment
walter g.
WG
All Oracle products have mobile versions. For development, try APEX.Read more
PostgreSQL
PostgreSQL Discussions
What are the advantages and disadvantages of PostgreSQL?
2 Comments
Alexandre G.
AG
Open Source: PostgreSQL is free and open-source software, meaning anyone can download, use, and modify it as needed without licensing costs. SQL...Read more
Can we get some video tutorials on usage? Also how do we connect them over cloud ?
1 Comment
Nigel H.
NH
Hey Jay, We use Postgresql on all of our cloud servers. We connect via SSL connections to the specific...Read more
What programs use PostgreSQL?
1 Comment