Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Editedit
PostgreSQL
Save to My Lists
Claimed
Claimed
This profile has been claimed by PostgreSQL, but it has limited features.
Do you work at PostgreSQL? Upgrade your plan to update branding and connect with profile visitors!

PostgreSQL Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users find PostgreSQL's ease of use exceptional, praising its user-friendly interface and straightforward setup. (14 mentions)
Users appreciate the robustness and feature-rich capabilities of PostgreSQL, highlighting its extensibility and community support. (8 mentions)
Users appreciate the open source nature of PostgreSQL, enhancing accessibility and flexibility for various applications. (7 mentions)
Users value the exceptional customer support of PostgreSQL, benefiting from its robust community and extensive features. (4 mentions)
Users value the easy integrations of PostgreSQL, simplifying their development process with seamless cloud connectivity and user-friendly tools. (4 mentions)
Users find PostgreSQL beginner-unfriendly, as its complex documentation makes initial usage challenging for newcomers. (7 mentions)
Users find the difficult learning curve of PostgreSQL challenging, especially during initial setup and feature understanding. (5 mentions)
Users experience slow performance with PostgreSQL, particularly during large data queries and when importing CSV files. (5 mentions)
Users find feature limitations in PostgreSQL, noting fewer configuration options and GUI tools compared to competitors. (3 mentions)
Users find the initial setup complexity of PostgreSQL challenging, especially for newcomers, despite its powerful features. (2 mentions)

Top Rated PostgreSQL Alternatives

RaimaDB
Visit WebsiteNew Tab
SponsoredYou’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
MySQL
(1,636)
4.4 out of 5
See all PostgreSQL Alternatives

638 PostgreSQL Reviews

4.4 out of 5
View 2 Video Reviews
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
  • Company SizeExpand/Collapse Company Size Filter
  • User RoleExpand/Collapse User Role Filter
  • CategoryExpand/Collapse Category Filter
  • IndustryExpand/Collapse Industry Filter
  • RegionExpand/Collapse Region Filter
The next elements are filters and will change the displayed results once they are selected.
  • Sort By:
    G2 Sort
638 PostgreSQL Reviews
4.4 out of 5
  • Sort By:
    G2 Sort
638 PostgreSQL Reviews
4.4 out of 5
  • Sort By:
    G2 Sort

PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
Here's how.
Verified User in Airlines/Aviation
UA
Enterprise (> 1000 emp.)
"Easy to use - Nice and provided feeling of organization"
What do you like best about PostgreSQL?

Felt organized, easy to understand and to use. Could keep several databases within eyes reach Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Occasional technical glitches, brief learning curve before becoming fluent with their system Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Enterprise (> 1000 emp.)
"One of the evergreen databases"
What do you like best about PostgreSQL?

Posgress is very light and flexible compared to mysql Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Do not have much documentation to start with Review collected by and hosted on G2.com.

AF
sql
Enterprise (> 1000 emp.)
"PostgreSQL Review"
Verified User in Retail
UR
Enterprise (> 1000 emp.)
"Great for Multithreaded applications"
What do you like best about PostgreSQL?

The great performance on top of the traditional DB ability to have a json data type really helps keep within the realm of SQL while creating a solid backend for microservices. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It has a little bit of learning curve but not necessarily anything bad I would say about postgresql Review collected by and hosted on G2.com.

Alexandr V.
AV
A
Enterprise (> 1000 emp.)
"Powerfull DB"
What do you like best about PostgreSQL?

A lot of features, smart backup, PG cluster ability, production ready DB Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Troubleshooting something hard to do, poor out of the box documentation Review collected by and hosted on G2.com.

Ajay S.
AS
System Engineer
Enterprise (> 1000 emp.)
"Best Open Source Relational Database"
What do you like best about PostgreSQL?

1) It can handle large amount of data securely without much difficulty.

2) It is secure.

3) It handles complex queries smoothly.

4) Creating and running Stored Procedures are easy and is handled without any issue.

5) Good to store large amount of structured data.

6) Provides some inbuilt data types to make working with data easier.

7) Many cloud platform like aws and azure supports PostgreSql.

8) Open source and free. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

1) Sometimes while creating connection it takes time.

2) Somewhat slow when you perform large data operations like updating and inserting.

3) Not very easy for beginners. Review collected by and hosted on G2.com.

Verified User in Financial Services
IF
Enterprise (> 1000 emp.)
"Best relational database system choice for new app developers"
What do you like best about PostgreSQL?

The performance of the database is topnotch relating to transactions, concurrency and schema controls Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is diffcult to resolve issues/errors as a lot of documentation is not available around this Review collected by and hosted on G2.com.

Syed M.
SM
Associate Consultant - (Data Engineering)
Mid-Market (51-1000 emp.)
"Open Source Transactional database to manage GB's of Data for Free."
What do you like best about PostgreSQL?

Free , Easy to connect over network has many features and Functions and Fast compared to MySql , Support from Large Community . Can have number of parallel users . Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

We need to have aliases for sub-queries which is an overhead sometimes when migrating from different database . Review collected by and hosted on G2.com.

Verified User in Education Management
IE
Enterprise (> 1000 emp.)
"PostgreSQL"
What do you like best about PostgreSQL?

The cost point on PostgreSQL is significantly better than the big guns like Oracle. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't think this is as redundant a solution or as high capacity as other databases. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Advance relational database for the low price."
What do you like best about PostgreSQL?

It's great enterprise sql quality database. Postgres better implements a lot of things in an open source as compared to Oracle. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Installation is confusing as compared to MySql. Has a lot of prerequisites. Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
View More Pricing Information
PostgreSQL Comparisons
Product Avatar Image
MySQL
Compare Now
Product Avatar Image
MariaDB
Compare Now
Product Avatar Image
Oracle Database
Compare Now
PostgreSQL Features
Storage
Availability
Stability
Text Search
Data Types
Operating Systems
Database Locking
Access Control
Data Concurrency
View More Features
Categories on G2
Relational Databases
Explore More
Where to find reliable partner relationship management tools
Leading software for media analysis
Best customer service software for my tech company
Where to find reliable partner relationship management tools
Leading software for media analysis
Best customer service software for my tech company
Leading third-party risk management software
Best operational risk tools for app developers
Pros and Cons Details
PostgreSQL