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

637 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.
637 PostgreSQL Reviews
4.4 out of 5
637 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.
Praneel Kumar P.
PP
Full time Research Scholar (Ph.D)
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

Ability to manage database securely and easily, easy to integrate to several applications. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing, so far everything is fine going Review collected by and hosted on G2.com.

UDDAGIRI S.
US
Assistant System Engineering
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

I can store data in relational database in the form of tables, views and functions Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Inserting row providing explicit value for Primary key even though default value defind Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising
AM
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

For the most part PostgreSQL performs well and does not catch you out too often. Various tuning options and ways to analyse performance so is not too tricky to keep it working well as you scale vertically. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lack of horizontal scaling options in the market make it tricky once you've either exhausted vertical scaling or are encountering issues with multiple read replicas. Review collected by and hosted on G2.com.

MO
Innovation Manager
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It is totally free; it has helped us to deploy our own web-based applications using RDBMS schemes; admin control is simple to deploy and maintain, it is also very well supported around the community Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Currently we have not found anything to dislike about postgreSQL, coming from MySQL I think postgreSQL it is very straight forward to use, and we haven't had any issues with it. Review collected by and hosted on G2.com.

Alejandro C.
AC
IT Head
Automotive
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is the most complete, safer, easier and more reliable database engine we use in the company. We administrate it through PG Admin, and we have allocated in the AWS instance. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It's tricky if you have invalid objects to assign permissions to different users o groups. But once you delete or repair the invalid objects, everything becomes more accessible. It is the only thing that i dislike. Review collected by and hosted on G2.com.

Shrijaya S.
SS
Senior Software Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

Supports wide range of query syntax and best in terms if usability. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Too many reserved keywords. With these many keywords we dont get to chosse meaningful column names due to reserved keyword restrictions. Review collected by and hosted on G2.com.

Mansi M.
MM
Software Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I like the best that it is widely used for enterprise software development, it has been in the industry for very long, thus it is reliable, robust and highly performant. It is fast and very easy to use. It also provides very detailed documentation along with detailed feature matrix for each version release. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing to dislike as such, but something that is very common in softwares is that latest version is never stable enough for production use. Review collected by and hosted on G2.com.

Mubeen A.
MA
SOC - Security Engineering Lead
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is a very robust and tested relational database known for its simple implementation and great features like fault tolerance, self recovery and detailed logging capabilities. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is a very old relational database which is not very efficient, it has not aged well and the current technology relevance is very limited. It is slow, not compatible with modern applications and lacks proper support and documentation. Review collected by and hosted on G2.com.

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

I like its capability to handle multi vendors. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It takes more time to get hands on experience than other RDBMS Review collected by and hosted on G2.com.

Shrijaya S.
SS
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Organic Review from User Profile
What do you like best about PostgreSQL?

Ease of use and too many features. Like the varchar limit is way more than we have in oracle Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It uses too much memory for processing complex queries Review collected by and hosted on G2.com.