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.
Abdulla C.
AC
Senior Manager - Digital Transformation Solutions
Enterprise (> 1000 emp.)
"PostgreSQL as persistence provider with IOT Platform -Thingworx"
What do you like best about PostgreSQL?

Performance and Ease of working with PostgreSQL with small to medium application development Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Scalability is limited, and performance degrades as scaled to large applications Review collected by and hosted on G2.com.

RN
Data Research Analyst
Mid-Market (51-1000 emp.)
"Best database in market"
What do you like best about PostgreSQL?

It works robustly, Well supported by backend frameworks. Stability and ability to handle structured data are pretty good. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Configuration can be a little overwhelming for those who are new, but users can refer - https://www.postgresql.org/docs/ for better understanding. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care
UH
Enterprise (> 1000 emp.)
"Powerful RDBMS"
What do you like best about PostgreSQL?

Opensource DB, Highly Secure, Stability, Scalability, Highly performance-oriented. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Data compression, Columns reordering, its default availability on all hosts. Review collected by and hosted on G2.com.

Kishan K.
KK
Data Analyst
Mid-Market (51-1000 emp.)
"Best Relational Database"
What do you like best about PostgreSQL?

1) It is a free and open-source database system.

2) It is secure and robust compared to other relational database systems.

3) Easy to store large amount of structured data in the database system.

4) Querying time is super fast and quick.

5) Frequent updates from time to time. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

1) It is a bit confusing compared to other database systems.

2) Sometimes slow with big queries.

3) Apart from these cons, it's a great relational database system. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Mid-Market (51-1000 emp.)
"Easily scalable database solution"
What do you like best about PostgreSQL?

The best thing is its is open source, it supports the B+ tree, GIN (Generalized Inverted Index) and GiST (Generalized Search Tree).The project is supported by a number of corporations and people. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Changes for performance enhancement need more work than in MySQL since PostgreSQL primarily has software compatibility goals. Many open source applications support MySQL, but not PostgreSQL. Review collected by and hosted on G2.com.

Animesh K.
AK
Technical Test Lead (ABC Financials)
Enterprise (> 1000 emp.)
"PostgreSQL - Advanced open source database"
What do you like best about PostgreSQL?

Easy Installation and Configuration, supports multi-platforms like Windows, macOS, Linux, use existing applications.

Highly reliable open source RDBMS.

Lots of features compared to its competitors. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lacks schema versioning, Parallel data query, Feels lacking in performance compared to competitors especially in writing to the database. Postgre upgrade from 9 to 10 was not that great, there was a lot of downtime. Lacks in-memory modes.

Less documentation which may be impediment to new users. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Small-Business (50 or fewer emp.)
"Good Database to integrate with Go"
What do you like best about PostgreSQL?

- Querying time is considerably faster

- Free and open-source database

- Easy to install and configure Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- Consumes somewhat higher CPU usage so that efficiency is a bit low Review collected by and hosted on G2.com.

Dinesh P.
DP
SDE
Small-Business (50 or fewer emp.)
"How postgreSQL helps me in my daily work"
What do you like best about PostgreSQL?

only postgresql provides enterprise-class performance and functions among current open source dbms with no end of development possibilities. also, postgresql users can directly participate in the community and post and share inconveniences and bugs. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The UI is not that user friendly. I could improve much better way. Review collected by and hosted on G2.com.

Verified User in Computer & Network Security
AC
Small-Business (50 or fewer emp.)
"Excellent for complex data queries"
What do you like best about PostgreSQL?

Highly compliant with SQL standards, able to handle large complex queries. Supported by the majority of platforms such as Amazon Redshift and DynamoDB. Great for application data processing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Slow process speed, not a good fit for real-time data processing Review collected by and hosted on G2.com.

Verified User in Insurance
AI
Enterprise (> 1000 emp.)
"A friendly Database"
What do you like best about PostgreSQL?

Is a good database for non-critical applications that required less level of effort for administration and support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

At the moment i do not find any dislike whatsoever 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