Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

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

MySQL
(1,636)
4.4 out of 5

638 PostgreSQL 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.
The next elements are filters and will change the displayed results once they are selected.
638 PostgreSQL Reviews
4.4 out of 5
638 PostgreSQL Reviews
4.4 out of 5

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.
Verified User in Information Technology and Services
UI
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Very reliable tool to use and easy to understand plus its consistent and also adapts to changing infrastructure in the market. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The documentation is very dense which is nit easy to understand by beginners. Review collected by and hosted on G2.com.

Kwabena A. B.
KB
IT Professional
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

PostgresSQL shines as an enterprise RDBMS. It has all the enterprise features of a modern database management system, yet it is free and open source. It can handle a data intensive system very well. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is really difficult to talk about any dislike about PostgreSQL, however it has a bit of a learning curve. Also, installation and configuration on a linux platform is a bit complicated. Review collected by and hosted on G2.com.

RL
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

-Scalability and Performance: PostgreSQL can handle high-volume workloads and scale to large datasets.

-Cross-Platform Compatibility: PostgreSQL runs on multiple platforms, including Linux, macOS, and Windows. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

-Configuration and Performance Tuning: Optimizing performance in PostgreSQL can be challenging, particularly for complex workloads and large datasets.

-Upgrade Process: Upgrading PostgreSQL to newer versions may require careful planning and testing, as it involves migrating data and ensuring compatibility with existing applications and extensions. Review collected by and hosted on G2.com.

Akash N.
AN
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

Postgresql is a platform that shares unlimited sources accessible to every user. Its user-friendly features make it easy for beginners to understand its functionalities.

Whether maintaining or exploring new databases or setting up your database from scratch, Postgresql is one of the best tool user can rely upon! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

While merging or blending data from different sources a few times, PostgreSQL lags or fails the first time, which can be a con for the platform, other than all other features work smoothly! Review collected by and hosted on G2.com.

Vladimir T.
VT
Ingeniero y Desarrollador
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Reliable: Even when there is no space in disk or with some hardware errors it can recover. Fast --it requires optimizing but it gives the tools to optimize. Open Source. Periodicaly updated. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For me that it uses Sql is a plus. But I guess for people who doesn't know Sql it may be hard, but it iw worth to learn it. Review collected by and hosted on G2.com.

Paresh K.
PK
Junior Software Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The main plus point about PostgreSQL is that it's an open-source R-DBMS that is very reliable, making it a first choice for startups and other organizations. Also, it has gained a high reputation for its high performance while handling high volumes of datasets very efficiently. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

One thing I feel that's a downside in PostgreSQL is that its GUI functionality is very limited and not that user-friendly, making it challenging for first-timers to use its complete functionalities, especially when they are not used to the command-line interface. Review collected by and hosted on G2.com.

Stefano A.
SA
Direttore Ricerca & Sviluppo
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
Rating Updated ()
What do you like best about PostgreSQL?

High compatibility with Oracle SQL and Oracle PL/SQL. With very few changes, you are able to migrate an Oracle Database to PostgreSQL. There are also a good choice for what concern high availability and load balancing solutions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL is able to manage JSON data with native datatype and APIs. But if you need to query datasets over 10 Gbytes of raw data, consider transforming JSON documents to normalized tables because queries may have time-out issues. Review collected by and hosted on G2.com.

Shubhi S.
SS
ETL Developer - Talend
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

It is open source and freely available, partitioning concept, sql compatibility , support Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

upgrade process support, complexity on performance tuning Review collected by and hosted on G2.com.

Yan A.
YA
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It has a rich and mature feature set where things like referential integrity weren't an afterthought (compared to MySQL). Documentation is also excellent, and modern ANSI SQL syntax is well supported. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It's not as widespread as MySQL is, so it can be harder to find people that are strong DBA skills or know the specifics of its internal workings, but it isn't that bad either. It's not like it's some unknown DBMS either, it's simply not as widespread as MySQL. Review collected by and hosted on G2.com.

Vivek D.
VD
Associate Technical Engineer I
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL provides an open-source environment to all users. It's easy to use and easy to understand it's functionality. Creating your own data set for testing or exploring new data set both work in the best way. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL is good for beginners but its integration parts didn't work properly. Such as JSON data or others. PostgreSQL needs to work on the integration part of this tool. Review collected by and hosted on G2.com.