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 Education Management
UE
Small-Business (50 or fewer emp.)
"PostgresSQL is a powerful database"
What do you like best about PostgreSQL?

It's very easy to set up, especially when using a managed service from a cloud provider. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Migrating when there are version upgrades can be a bit of a pain. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"PostgreSQL is open source for all OS"
What do you like best about PostgreSQL?

PostgreSQL is open source, and we can use it in any OS like Windows, Linux, etc. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

A stored procedure is not fully supported here, and we can not return a dynamic table. Also, his output window returns only a single query result. Review collected by and hosted on G2.com.

Naveed A.
NA
Angular & React Developer
Small-Business (50 or fewer emp.)
"PostGreSQL Developer Experience"
What do you like best about PostgreSQL?

The relations among the tables to avoid duplicate data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Limited JSON data support therefore we need many number of tables Review collected by and hosted on G2.com.

Verified User in Automotive
UA
Enterprise (> 1000 emp.)
"Working on SQL with PostgreSQL"
What do you like best about PostgreSQL?

The code/Query you type in the database, if overwritten by another new query by user, the previous query /Queries will still be available in the history, which you can easily refer to and copy the old code Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There's not much to Dislike to be honest - but every database may have some or the other query restricted limitations. Such as, in PostgreSQL I could'nt use the LIMIT command and few more - which were working in MySQL server. But other major things were working fine only. Review collected by and hosted on G2.com.

Prasad B.
PB
Principal Consultant
Enterprise (> 1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"SQL with most user friendly behaviour."
What do you like best about PostgreSQL?

- Easy to code and interpret.

- DB compatible Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- Need to get more in-built libraries and opcodes. Review collected by and hosted on G2.com.

Franco M.
FM
PLSQL Developer
Small-Business (50 or fewer emp.)
"Postgresql solve it for free"
What do you like best about PostgreSQL?

It's similar to oracle and mysql but it's free Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

UI is not the best. Could be even better. Review collected by and hosted on G2.com.

Jagruti P.
JP
Senior Analyst
Enterprise (> 1000 emp.)
"PostgreSQL Review and experience on my point of view"
What do you like best about PostgreSQL?

- Simplicity and flexibility compared to other SQL databases.

- Logging is available for each and every activity if you eneabled that so its easy to understand if some users has changed any data.

- We can use complex data types which is available in postgres like geographic objects which help us to manage location data in the database if your application needs to manage user or other location.

- English Documenetation available for easy of use and that will not take much time to learn this database Software. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- The speed of fetching data is very low compare to others.

- Each and every open source software not support PostgreSQL compare to mySQL which support most of each and every open source sotware. Review collected by and hosted on G2.com.

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

When you think about the performance of a database and it's robustness postgresql is the best option. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Pg admin should be simplified,some times split windows are too crowded to look at. Review collected by and hosted on G2.com.

Charlie O.
CO
CTO
Small-Business (50 or fewer emp.)
"I've learned to use Postgres for everything unless there's very good reason not to"
What do you like best about PostgreSQL?

Postgres is rock solid, widely available, and very performant. In my opinion it is usually best to start with everything in Postgres and spin things out as you scale. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much; integrated connection pooling would be nice. And a native column store option. Review collected by and hosted on G2.com.

Wade W.
WW
Director of Information and Analytics
Mid-Market (51-1000 emp.)
"THE preferred solution for an open source relation database"
What do you like best about PostgreSQL?

Postgres has many of the features that I have come to enjoy in more enterprise-scale databases, with the benefit of an open-source pricetag and community support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you are looking for a vendor, Postgres isn't your tool. In many ways though, that is a positive. 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

$$$$$
PostgreSQL