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.
Noah S.
NS
Technical Consultant
Enterprise (> 1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Best Open Source RDBMS for Beginners"
What do you like best about PostgreSQL?

It's the easiest RDBMS for beginners with relatively simple syntax & very little administration required for basic apps. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is slower than MySQL and other non-RDBMS databases. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Upgrade from MYSql"
What do you like best about PostgreSQL?

Ease of use and functionality: being able to schedule tasks, create window functions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Finding small syntax differences between mysql and postgresql Review collected by and hosted on G2.com.

Hendy W.
HW
Senior Associate Consultant
"Good and I want to experience or solve more problem using it."
What do you like best about PostgreSQL?

Simple interface, and easy for beginner (either for student or associate consultant) Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

pip install are a lot, and it required one to do more research. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Small-Business (50 or fewer emp.)
"Best professional open source RDBMS"
What do you like best about PostgreSQL?

High SQL standard coverage, feature rich and easy to use and deploy. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you need a database server, there are no real downsides. Point in time recovery is some work to set up. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
II
Mid-Market (51-1000 emp.)
"Best Database to use in production."
What do you like best about PostgreSQL?

Postgres provide very amazing fields which other SQL database doesn't have like array field and json field to store data, postgres is very easy to integrate and very much easy to use too. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres installation with linux mint is bit difficult the documentation provided to install doesn't work properly with linux mint. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Enterprise (> 1000 emp.)
"postgre"
What do you like best about PostgreSQL?

easy to excecute the scripts,easy to find the database and tables, proper arrangement of views & tables. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

connecting to server , requires additional host names and details Review collected by and hosted on G2.com.

zahit B.
ZB
BI & DWH Consultant
Mid-Market (51-1000 emp.)
"Great To Manage Multiple Databases"
What do you like best about PostgreSQL?

I think PostgreSQL is a good Enterprise Class data management. It has good amount of features like integration, migration, flexible deployment options, has good tool kits for management. We've almost about 10+ databases including master and managing them via PostgreSQL is very easy. One good thing with PostgreSQL is that we can have multiple databases in single server and having different configurations for them. Overall we are most satisfied with PostgreSQL and their services. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Ability to have multiple databases on single server. Having database users which are permission based Integration between multiple databases. Review collected by and hosted on G2.com.

zahit b.
ZB
Freelance BI&DWH Consultant
Small-Business (50 or fewer emp.)
"Open Source Database Management"
What do you like best about PostgreSQL?

PostgreSQL is an open-source database. It is an RDBMS. In our Organization, we are using PostgreSQL-9.4 and planning to upgrade it to 9.5 in future. PostgreSQL Database can be used for highly complex applications. It will reject the unauthorized connections to the database. In addition, The management panel for storage management is very useful. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Configuring the Database in the local machine was a bit difficult. I don't find any good IDE's to work on it. PgAdmin's also there, I couldn't achieve the maximum speed. Because it's a web-based application Review collected by and hosted on G2.com.

Andy Larry R.
AR
Informaticien études et développement
Small-Business (50 or fewer emp.)
"Best scalable and stable RDBMS i ever use"
What do you like best about PostgreSQL?

- A very scalable data management system with powerful tools to exploit data

- A strong stability when execute complex request (trigger, ) and long term data archive

- A great stability for data storage, no data corrupted, no crash, it can store big data

- Open source and free, you can deploy PostgreSQL anywhere and anytime with sevral users as you want

- Very best support team with community Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- You must regularly execute autovacuum to insure performance

- It 'is a little complicated to implement logshipping master/slave clusterization

- Not as speed as Mysql for data selection (SELECT)

- Detailed documentation only available in English version Review collected by and hosted on G2.com.

Verified User in Accounting
UA
Small-Business (50 or fewer emp.)
"Awesome"
What do you like best about PostgreSQL?

I've used Postgres for a number of projects and would highly recommend. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

At this time, nothing comes to mind so far 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
Categories on G2
Relational Databases
Explore More
Best cloud-based EDI solution
Best contact center solution for a growing business
Top PRM platforms to improve partner collaboration
Best cloud-based EDI solution
Best contact center solution for a growing business
Top PRM platforms to improve partner collaboration
What's the best cloud service for internal projects
Best SaaS backup software for small businesses
Pros and Cons Details

PostgreSQL Comparisons

Compare PostgreSQL vs. MySQL
Compare PostgreSQL vs. MySQL
PostgreSQLVSMySQL
Compare PostgreSQL vs. MariaDB
Compare PostgreSQL vs. MariaDB
PostgreSQLVSMariaDB
Compare Oracle Database vs. PostgreSQL
Compare Oracle Database vs. PostgreSQL
PostgreSQLVSOracle Database
Compare PostgreSQL ratings to similar products
PostgreSQL