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

Compare MySQL and PostgreSQL

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
MySQL
MySQL
Star Rating
(1,668)4.4 out of 5
Market Segments
Small-Business (36.7% of reviews)
Information
Pros & Cons
Entry-Level Pricing
$5,000
Browse all 3 pricing plans
PostgreSQL
PostgreSQL
Star Rating
(668)4.4 out of 5
Market Segments
Small-Business (35.8% of reviews)
Information
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about PostgreSQL
AI Generated Summary
AI-generated. Powered by real user reviews.
  • G2 reviewers report that MySQL excels in ease of learning, making it a go-to choice for newcomers. Users appreciate its lightweight nature and reliable performance, especially for website backends, which contributes to its strong reputation over the years.
  • According to verified reviews, PostgreSQL stands out for its robust feature set that supports complex SQL queries. Users highlight its capabilities with functions, triggers, and materialized views, making it a powerful tool for advanced database management.
  • Reviewers mention that MySQL's querying and indexing capabilities are impressive, with modern features like Common Table Expressions (CTEs) enhancing its functionality. This makes it a solid choice for users needing efficient data retrieval and manipulation.
  • Users say that PostgreSQL's reliability and data integrity are unmatched, with many reporting years of trouble-free operation in production environments. Its strong ACID compliance is a significant factor for those prioritizing data safety.
  • G2 reviewers note that while both databases offer good support, MySQL slightly edges out with its performance monitoring tools and replication features, which users find particularly beneficial for maintaining database performance and uptime.
  • According to recent feedback, PostgreSQL's customizability and ability to run on minimal hardware configurations are major advantages for small businesses looking to save on infrastructure costs, making it a flexible option for various use cases.
Pricing
Entry-Level Pricing
MySQL
MySQL Enterprise Edition
$5,000
Browse all 3 pricing plans
PostgreSQL
No pricing available
Free Trial
MySQL
No trial information available
PostgreSQL
No trial information available
Ratings
Meets Requirements
8.9
1,399
9.1
545
Ease of Use
8.7
1,402
8.5
550
Ease of Setup
8.6
665
8.4
279
Ease of Admin
8.4
635
8.2
250
Quality of Support
8.0
1,180
7.9
441
Has the product been a good partner in doing business?
8.5
520
8.5
199
Product Direction (% positive)
8.0
1,366
8.5
532
Features by Category
8.7
1,284
8.9
507
Management
9.0
144
9.1
122
9.1
144
9.1
120
8.9
131
9.1
107
8.8
126
8.9
111
Support
8.4
135
8.6
113
8.7
141
9.2
124
8.9
135
9.1
111
9.1
133
9.1
113
Security
8.8
134
8.7
114
8.9
134
8.9
116
8.6
128
8.6
108
8.6
133
8.9
110
Performance
8.4
126
8.6
106
8.6
128
8.8
112
8.5
128
8.6
107
8.6
129
8.8
111
8.6
128
8.6
110
Database Features
8.8
1148
9.0
460
8.9
1154
9.0
465
8.7
1157
9.0
470
8.1
1125
8.6
452
8.4
1115
8.7
439
8.7
1128
8.8
453
8.9
1149
9.0
461
Categories
Categories
Shared Categories
MySQL
MySQL
PostgreSQL
PostgreSQL
MySQL and PostgreSQL are categorized as Relational Databases
Unique Categories
MySQL
MySQL has no unique categories
PostgreSQL
PostgreSQL has no unique categories
Reviews
Reviewers' Company Size
MySQL
MySQL
Small-Business(50 or fewer emp.)
36.7%
Mid-Market(51-1000 emp.)
30.9%
Enterprise(> 1000 emp.)
32.5%
PostgreSQL
PostgreSQL
Small-Business(50 or fewer emp.)
35.8%
Mid-Market(51-1000 emp.)
33.9%
Enterprise(> 1000 emp.)
30.4%
Reviewers' Industry
MySQL
MySQL
Information Technology and Services
25.1%
Computer Software
20.5%
Internet
4.5%
Higher Education
4.2%
Education Management
3.3%
Other
42.4%
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
MySQL
MySQL Alternatives
Microsoft SQL Server
MS SQL
Add Microsoft SQL Server
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
PostgreSQL
PostgreSQL Alternatives
Microsoft SQL Server
MS SQL
Add Microsoft SQL Server
Oracle Database
Oracle Database
Add Oracle Database
Amazon Relational Database Service (RDS)
Amazon Relational Database Service (RDS)
Add Amazon Relational Database Service (RDS)
IBM Db2
IBM Db2
Add IBM Db2
Discussions
MySQL
MySQL Discussions
Does MySQL new version has strong security?
10 Comments
JH
here is list of some overlooked security holes in MySql: update the password plugin; password for the root account root accounts that are...Read more
Can I use MySQL for free?
3 Comments
Shivangini R.
SR
Yes you can because it's a open source software and offers MySQL Schema, workbench, etc. You can easily download MySQL Software from the Internet and start...Read more
What is MySQL used for?
3 Comments
Shivangini R.
SR
MySQL is a relational database management system, and as its name suggests you can easily import, export, and manipulate data file upto 10 TBSs. It also lets...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