Introducing G2.ai, the future of software buying.Try now
RaimaDB
Sponsored
RaimaDB
Visit Website
PostgreSQL
Editedit
Product Avatar Image
PostgreSQL

By PostgreSQL

4.4 out of 5 stars
5 star
67%
4 star
27%
3 star
5%
2 star
0%
1 star
0%

How would you rate your experience with PostgreSQL?

See all 665 PostgreSQL reviews
RaimaDB
Sponsored
RaimaDB
Visit Website

PostgreSQL Pros and Cons: Top Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users value the extensibility and wide range of features in PostgreSQL, enhancing flexibility and performance in data management. (14 mentions)
Users find PostgreSQL to be easy to use, highlighting its user-friendly pgAdmin UI and effortless integration with Python. (11 mentions)
Users value the scalability of PostgreSQL, as it seamlessly handles both small projects and large enterprise systems. (9 mentions)
Users value PostgreSQL for its exceptional reliability, ensuring safe transactions with ACID compliance and robust concurrency. (8 mentions)
Users value the open-source nature of PostgreSQL, enabling cost-effective and customizable database solutions for various projects. (7 mentions)
Users value the flexibility of PostgreSQL, appreciating its extensibility and customization options for diverse projects. (6 mentions)
Users find easy integrations with PostgreSQL, effortlessly implementing it across various systems and programming languages. (5 mentions)
Users value the excellent customer support for PostgreSQL, enhancing their experience with its robust features and reliability. (4 mentions)
Users praise the user-friendly interface of PostgreSQL, making database management and integration with Python effortless. (4 mentions)
Users find PostgreSQL's beginner unfriendliness daunting due to its steep learning curve and complex advanced configurations. (7 mentions)
Users find the syntax complex and at times confusing, especially compared to more straightforward alternatives like MySQL. (5 mentions)
Users find PostgreSQL's steeper learning curve challenging, especially for complex configurations and advanced features. (5 mentions)
Users find difficult learning curves challenging, especially with advanced features that demand significant expertise and time investment. (4 mentions)
Users note the high hardware requirements of PostgreSQL, impacting performance and resource usage during operation. (4 mentions)
Users experience slow performance with large datasets, requiring manual tuning and proper indexing for optimal results. (4 mentions)
Users experience slowness with large data in PostgreSQL, requiring meticulous indexing to optimize performance. (1 mentions)
Users find fewer GUI tools available in PostgreSQL compared to databases like MySQL, limiting usability options. (1 mentions)
Users experience performance issues with PostgreSQL, particularly when executing large or complex queries, causing application unresponsiveness. (1 mentions)

Top Pros or Advantages of PostgreSQL

1. Features
Users value the extensibility and wide range of features in PostgreSQL, enhancing flexibility and performance in data management.
See 14 mentions

See Related User Reviews

Conor M.
CM

Conor M.

Small-Business (50 or fewer emp.)

4.5/5

"Reliable DB System"

What do you like about PostgreSQL?

What I like best about PostgreSQL is that it feels like a complete database out of the box while still being incredibly flexible. It has strong suppor

Chiradeep B.
CB

Chiradeep B.

Enterprise (> 1000 emp.)

5.0/5

"Comprehensive SQL Features That Exceed Expectations"

What do you like about PostgreSQL?

The best part is the wide range of features enabling to execute complex sql queries in terms of working with function , trigger, cursor, views, materi

2. Ease of Use
Users find PostgreSQL to be easy to use, highlighting its user-friendly pgAdmin UI and effortless integration with Python.
See 11 mentions

See Related User Reviews

Anthony Manuel B.
AB

Anthony Manuel B.

Mid-Market (51-1000 emp.)

4.0/5

"Reliable and Scalable Open-Source Database for Complex Applications"

What do you like about PostgreSQL?

PostgreSQL offers exceptional reliability and flexibility for both transactional and analytical workloads. I appreciate its strong ACID compliance, ro

NAYAN K.
NK

NAYAN K.

Mid-Market (51-1000 emp.)

5.0/5

"PostgreSQL: Most popular SQL DBMS Software"

What do you like about PostgreSQL?

Simple and Easy to use. I really like the PG admin UI which is really very user friendly. Installed and Builder stack are easy to implement. Can conne

3. Scalability
Users value the scalability of PostgreSQL, as it seamlessly handles both small projects and large enterprise systems.
See 9 mentions

See Related User Reviews

Conor M.
CM

Conor M.

Small-Business (50 or fewer emp.)

4.5/5

"Reliable DB System"

What do you like about PostgreSQL?

What I like best about PostgreSQL is that it feels like a complete database out of the box while still being incredibly flexible. It has strong suppor

Alvaro I.
AI

Alvaro I.

Mid-Market (51-1000 emp.)

4.5/5

"Reliable, Powerful, and My Go-To Database"

What do you like about PostgreSQL?

PostgreSQL is always my go-to option when beginning a new project. Being open-source, it allows you to cut costs while still offering impressive power

4. Reliability
Users value PostgreSQL for its exceptional reliability, ensuring safe transactions with ACID compliance and robust concurrency.
See 8 mentions

See Related User Reviews

Conor M.
CM

Conor M.

Small-Business (50 or fewer emp.)

4.5/5

"Reliable DB System"

What do you like about PostgreSQL?

What I like best about PostgreSQL is that it feels like a complete database out of the box while still being incredibly flexible. It has strong suppor

Anthony Manuel B.
AB

Anthony Manuel B.

Mid-Market (51-1000 emp.)

4.0/5

"Reliable and Scalable Open-Source Database for Complex Applications"

What do you like about PostgreSQL?

PostgreSQL offers exceptional reliability and flexibility for both transactional and analytical workloads. I appreciate its strong ACID compliance, ro

5. Open Source
Users value the open-source nature of PostgreSQL, enabling cost-effective and customizable database solutions for various projects.
See 7 mentions

See Related User Reviews

Anthony Manuel B.
AB

Anthony Manuel B.

Mid-Market (51-1000 emp.)

4.0/5

"Reliable and Scalable Open-Source Database for Complex Applications"

What do you like about PostgreSQL?

PostgreSQL offers exceptional reliability and flexibility for both transactional and analytical workloads. I appreciate its strong ACID compliance, ro

Balkishan N.
BN

Balkishan N.

Mid-Market (51-1000 emp.)

4.0/5

"Deep Dive into PostgreSQL: A Comprehensive Review"

What do you like about PostgreSQL?

1) Open-source and free 2) Highly reliable and ACID compliant 3) Supports complex queries and JSONB 4) Extensible (custom types, functions, extensi

6. Flexibility
Users value the flexibility of PostgreSQL, appreciating its extensibility and customization options for diverse projects.
See 6 mentions

See Related User Reviews

Conor M.
CM

Conor M.

Small-Business (50 or fewer emp.)

4.5/5

"Reliable DB System"

What do you like about PostgreSQL?

What I like best about PostgreSQL is that it feels like a complete database out of the box while still being incredibly flexible. It has strong suppor

Alvaro I.
AI

Alvaro I.

Mid-Market (51-1000 emp.)

4.5/5

"Reliable, Powerful, and My Go-To Database"

What do you like about PostgreSQL?

PostgreSQL is always my go-to option when beginning a new project. Being open-source, it allows you to cut costs while still offering impressive power

7. Easy Integrations
Users find easy integrations with PostgreSQL, effortlessly implementing it across various systems and programming languages.
See 5 mentions

See Related User Reviews

Blas C.
BC

Blas C.

Mid-Market (51-1000 emp.)

5.0/5

"Powerful relational database easy to integrate"

What do you like about PostgreSQL?

Offers all features you can expect from a relational database as well as a lot of features from NoSql. Easy to integrate with multiple clients.

Isaac B.
IB

Isaac B.

Small-Business (50 or fewer emp.)

5.0/5

"My Go-To Database for Every Project"

What do you like about PostgreSQL?

This is one of my favorite databases. It allows me to get set up fast and handle any workload. I love using it with Prisma, I love using it with Ruby

8. Customer Support
Users value the excellent customer support for PostgreSQL, enhancing their experience with its robust features and reliability.
See 4 mentions

See Related User Reviews

Sarthak D.
SD

Sarthak D.

Enterprise (> 1000 emp.)

5.0/5

"Powerful, Flexible, and Reliable Relational Database Solution"

What do you like about PostgreSQL?

PostgreSQL is the most abstract form of relational databases that provides ease of normalization, handling multiple databases, and transactions. All A

Aavinashh L.
AL

Aavinashh L.

Enterprise (> 1000 emp.)

4.5/5

"PostgreSQL is robust database to rely on."

What do you like about PostgreSQL?

Its wonderful DBMS that has wide range of extentions and relaibiility features with great customer support

9. User Interface
Users praise the user-friendly interface of PostgreSQL, making database management and integration with Python effortless.
See 4 mentions

See Related User Reviews

Conor M.
CM

Conor M.

Small-Business (50 or fewer emp.)

4.5/5

"Reliable DB System"

What do you like about PostgreSQL?

What I like best about PostgreSQL is that it feels like a complete database out of the box while still being incredibly flexible. It has strong suppor

Dhiraj D.
DD

Dhiraj D.

Enterprise (> 1000 emp.)

5.0/5

"Best DB workbench"

What do you like about PostgreSQL?

It's user interface is very friendly. It easily give data modification table , schema , views create scripts.

Top Cons or Disadvantages of PostgreSQL

1. Beginner Unfriendliness
Users find PostgreSQL's beginner unfriendliness daunting due to its steep learning curve and complex advanced configurations.
See 7 mentions

See Related User Reviews

Anthony Manuel B.
AB

Anthony Manuel B.

Mid-Market (51-1000 emp.)

4.0/5

"Reliable and Scalable Open-Source Database for Complex Applications"

What do you dislike about PostgreSQL?

While PostgreSQL is extremely powerful, it can be intimidating for newcomers. Some advanced configurations—like connection pooling or query planner tu

Balkishan N.
BN

Balkishan N.

Mid-Market (51-1000 emp.)

4.0/5

"Deep Dive into PostgreSQL: A Comprehensive Review"

What do you dislike about PostgreSQL?

1) Slower for simple read-heavy workloads 2) Requires manual tuning for performance 3) Replication/sharding setup is complex 4) Steeper learning cu

2. Complexity
Users find the syntax complex and at times confusing, especially compared to more straightforward alternatives like MySQL.
See 5 mentions

See Related User Reviews

Blas C.
BC

Blas C.

Mid-Market (51-1000 emp.)

5.0/5

"Powerful relational database easy to integrate"

What do you dislike about PostgreSQL?

Sometimes depending on the query the syntax is a little bit complex

Anshu K.
AK

Anshu K.

Small-Business (50 or fewer emp.)

3.5/5

"Postgres SQL: Great Database"

What do you dislike about PostgreSQL?

It has more features so sometimes confuses us

3. Learning Curve
Users find PostgreSQL's steeper learning curve challenging, especially for complex configurations and advanced features.
See 5 mentions

See Related User Reviews

Anthony Manuel B.
AB

Anthony Manuel B.

Mid-Market (51-1000 emp.)

4.0/5

"Reliable and Scalable Open-Source Database for Complex Applications"

What do you dislike about PostgreSQL?

While PostgreSQL is extremely powerful, it can be intimidating for newcomers. Some advanced configurations—like connection pooling or query planner tu

Balkishan N.
BN

Balkishan N.

Mid-Market (51-1000 emp.)

4.0/5

"Deep Dive into PostgreSQL: A Comprehensive Review"

What do you dislike about PostgreSQL?

1) Slower for simple read-heavy workloads 2) Requires manual tuning for performance 3) Replication/sharding setup is complex 4) Steeper learning cu

4. Difficult Learning
Users find difficult learning curves challenging, especially with advanced features that demand significant expertise and time investment.
See 4 mentions

See Related User Reviews

Anthony Manuel B.
AB

Anthony Manuel B.

Mid-Market (51-1000 emp.)

4.0/5

"Reliable and Scalable Open-Source Database for Complex Applications"

What do you dislike about PostgreSQL?

While PostgreSQL is extremely powerful, it can be intimidating for newcomers. Some advanced configurations—like connection pooling or query planner tu

Ravi P.
RP

Ravi P.

Small-Business (50 or fewer emp.)

4.5/5

"A rock-solid, feature-rich database that grows with your needs"

What do you dislike about PostgreSQL?

The main challenge is that advanced tuning and optimization require expertise — features like partitioning, replication, or query optimization aren’t

5. High Hardware Requirements
Users note the high hardware requirements of PostgreSQL, impacting performance and resource usage during operation.
See 4 mentions

See Related User Reviews

Aavinashh L.
AL

Aavinashh L.

Enterprise (> 1000 emp.)

4.5/5

"PostgreSQL is robust database to rely on."

What do you dislike about PostgreSQL?

It has one feature that needs improvement on resources useage as it uses lots of your system resources.

Balkishan N.
BN

Balkishan N.

Mid-Market (51-1000 emp.)

4.0/5

"Deep Dive into PostgreSQL: A Comprehensive Review"

What do you dislike about PostgreSQL?

1) Slower for simple read-heavy workloads 2) Requires manual tuning for performance 3) Replication/sharding setup is complex 4) Steeper learning cu

6. Slow Performance
Users experience slow performance with large datasets, requiring manual tuning and proper indexing for optimal results.
See 4 mentions

See Related User Reviews

Balkishan N.
BN

Balkishan N.

Mid-Market (51-1000 emp.)

4.0/5

"Deep Dive into PostgreSQL: A Comprehensive Review"

What do you dislike about PostgreSQL?

1) Slower for simple read-heavy workloads 2) Requires manual tuning for performance 3) Replication/sharding setup is complex 4) Steeper learning cu

Arvind T.
AT

Arvind T.

Mid-Market (51-1000 emp.)

4.5/5

"Great Functionality, but Long Queries Can Slow Down the Database"

What do you dislike about PostgreSQL?

Actually postgresql used MVVM pattern and run query on core base so if any query take long time to run so it busy complete database.

7. Data Management
Users experience slowness with large data in PostgreSQL, requiring meticulous indexing to optimize performance.
See 1 mentions

See Related User Reviews

Mahesh B.
MB

Mahesh B.

Mid-Market (51-1000 emp.)

4.5/5

"Good Database for Web Applications"

What do you dislike about PostgreSQL?

When the data is large , it is little slow and also we need maintain proper indexing for every thing.

8. Feature Limitations
Users find fewer GUI tools available in PostgreSQL compared to databases like MySQL, limiting usability options.
See 1 mentions

See Related User Reviews

Akshay P.
AP

Akshay P.

Small-Business (50 or fewer emp.)

4.5/5

"PostgreSQL Performance Insights"

What do you dislike about PostgreSQL?

one thing i.e. fewer GUI tools compared to other database like MySQL

9. Performance Issues
Users experience performance issues with PostgreSQL, particularly when executing large or complex queries, causing application unresponsiveness.
See 1 mentions

See Related User Reviews

Dhiraj D.
DD

Dhiraj D.

Enterprise (> 1000 emp.)

5.0/5

"Best DB workbench"

What do you dislike about PostgreSQL?

Sometimes it's crashes when we run heavy queries

PostgreSQL Reviews (665)

View 2 Video Reviews
Reviews

PostgreSQL Reviews (665)

View 2 Video Reviews
4.4
665 reviews
Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
Here's how.
Ansu A.
AA
Data Analyst
Small-Business (50 or fewer emp.)
More Options
"free and extreme ease of access"
What do you like best about PostgreSQL?

The language used is universal to most query tools which makes it an easy tool to use and experiment. And learning ina free environment is super helpful Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Drag and drop of data values in not available in the latest version, as this feature is available in other editors this was expected and would have been helpful Review collected by and hosted on G2.com.

Divyarajsinh C.
DC
Junior Software Engineer
Information Technology and Services
Mid-Market (51-1000 emp.)
More Options
"Recommended Everyone To Use This Product Once."
What do you like best about PostgreSQL?

- The cost(minimal)

- Robust

- Scalability Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When I use some specific features, it gets stuck. Review collected by and hosted on G2.com.

Ayushi P.
AP
Analyst
Enterprise (> 1000 emp.)
More Options
"Exploring PostgreSQL"
What do you like best about PostgreSQL?

PostgreSQL, or "Postgres", is an open-source relational database management system (RDBMS).PostgreSQL, or "Postgres", is an open source relational database management system (RDBMS). It supports multiple programming languages, making it easy to develop applications using your preferred language. Unlike some other popular database solutions, such as MySQL and Microsoft SQL Server, PostgreSQL is 100% free and open source. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

One major disadvantage of PostgreSQL is that it doesn't enjoy as much support from software companies as other database systems like Microsoft SQL Server and Oracle. This can mean that you may find it difficult to find commercial software that supports PostgreSQL and that integrates well with your existing system. Another issue with PostgreSQL is that it can be difficult to upgrade to newer versions. If your company relies on upgrading its database system regularly in order to stay competitive, then you may not want to choose PostgreSQL.Finally, some businesses may find that they need more features than what's offered byPostgreSQL when compared to other enterprise-level database systems. These features may include complex security controls, data replication and mirroring, and advanced performance tuning options. Review collected by and hosted on G2.com.

Amir R.
AR
Engineering Manager
Financial Services
Mid-Market (51-1000 emp.)
More Options
"Postgres review"
What do you like best about PostgreSQL?

It is a flexible, fast RDBMS, with a lot of features Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is nothing wrong with this databased server. Review collected by and hosted on G2.com.

Farhan S.
FS
Software Developer
Mid-Market (51-1000 emp.)
More Options
"PostgreSQL Review Analysis"
What do you like best about PostgreSQL?

PostgreSQL is a fast, secure and reliable database to store relational data. It also supports ACID properties, so we stored sensitive data there. It is a open source platform so that we don't have to buy any subscription to use this database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL is not suitable for using JSON-like data structures. Also, it's not always available to every server; you must install it explicitly. PostgreSQL has a relatively slow query speed as compared to MySQL database. Review collected by and hosted on G2.com.

vijay b.
VB
Software Engineer
Mid-Market (51-1000 emp.)
More Options
"Best Open-Source Relational Database Management System"
What do you like best about PostgreSQL?

PostgreSQL is an Open Source Database that is used for mainly Relational database Systems. We are mainly using this database because of the microservice structure. And in microservices, we have a lot of databases and also it's open source so that is good for our organization. And it's an object-relational database the performance of the database is pretty good. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The documentation of PostgreSQL is not great. For beginners, it will be complex. and the second thing is the interface of PostgreSQL is not great. Review collected by and hosted on G2.com.

Pulkit G.
PG
Software Developer
Mid-Market (51-1000 emp.)
More Options
"Good for structure query language. Similar to MySQL"
What do you like best about PostgreSQL?

It has a good viewing App in which you can see all your schemas, tables, sequences, and many more. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is a bit difficult to integrate at the start. Review collected by and hosted on G2.com.

Shoaib T.
ST
Data Scientist
Small-Business (50 or fewer emp.)
More Options
"Efficient and free"
What do you like best about PostgreSQL?

The best part is that it is free to use and open-source. The installation was super easy because there are plenty of guides available online. We have been using this to gather tweets, and it has made our job easier. Not only that, but it is user-friendly. It also allows for scalability, which is a bonus. As tweets are saved in json it is easier to go through them without anything crashing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is just one teeny issue and that is when you are trying to configure it, there can be some errors which can't be fixed. I was unable to find the solution till I Googled it and found it on a tech website which explained how to sort it out. This configuration issue occurred a year ago and it has yet to be fixed in the new release. Review collected by and hosted on G2.com.

Praneel Kumar P.
PP
Full time Research Scholar (Ph.D)
Small-Business (50 or fewer emp.)
More Options
"PostgreSQL"
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
"Azure postgre"
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.

Categories on G2
Relational Databases
Explore More
Top platforms for managing employee vacation and sick leave
Recommended software for building an online community
Affordable session replay services for medium-sized ecommerce sites
Top platforms for managing employee vacation and sick leave
Recommended software for building an online community
Affordable session replay services for medium-sized ecommerce sites
Writeup
Best marketing analytics solutions for SMBs
Pros and Cons Details
Product Avatar Image
View Alternatives
Product Avatar Image
PostgreSQL
View Alternatives