The G2 on PostgreSQL

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Enterprise (> 1000 emp.)

5.0/5

"Best DB workbench"

What do you dislike about PostgreSQL?

Sometimes it's crashes when we run heavy queries

Top-Rated Alternatives

View All Alternatives

PostgreSQL Reviews (665)

View 2 Video Reviews

G2 reviews are authentic and verified.

Here's how.

Akash N.

Enterprise (> 1000 emp.)

6/7/2023

"One of the best and free DBMS in the market!"

5/5

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.

Ingeniero y Desarrollador

Small-Business (50 or fewer emp.)

5/22/2023

"Most reliable database"

5/5

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.

Junior Software Engineer

Mid-Market (51-1000 emp.)

2/22/2023

"The most powerful, feature-rich open-source relational database management system"

4/5

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.

What problems is PostgreSQL solving and how is that benefiting you?

PostgreSQL helped us while working on a web application as the backend database management system, which was built on top of Java the main reason I chose this was that it was open-source and had a vast community, which was needed when we got stuck in some problem. Also because of the flexibility and its performance, it was the best option for us. Review collected by and hosted on G2.com.

Stefano A.

Direttore Ricerca & Sviluppo

Enterprise (> 1000 emp.)

1/10/2023

"PostgreSQL: a good alternative to Oracle RDBMS"

4.5/5

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.

ETL Developer - Talend

Enterprise (> 1000 emp.)

10/4/2023

"Open source Database -PostgreSQL"

4.5/5

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.

Mid-Market (51-1000 emp.)

4/20/2023

"Great database with mature capabilities"

4.5/5

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.

Associate Technical Engineer I

Enterprise (> 1000 emp.)

5/4/2023

"Best Relational DBMS in market"

4.5/5

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.

Ayesh N.

Senior Software Engineer

Mid-Market (51-1000 emp.)

9/18/2023

"PostgreSQL in my eye"

4/5

What do you like best about PostgreSQL?

Since this is an open-source product, this really helps with day-to-day database development. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't really like the user interface, compared to other popular products like SSMS. Sometimes the UI lags. Review collected by and hosted on G2.com.

Harsh P.

SDE2

Information Services

Enterprise (> 1000 emp.)

4/24/2023

"Excellent Product"

5/5

What do you like best about PostgreSQL?

I like the UI of it. The security part is amazing. I really loved the product, and I am continuously using it in day-to-day work, also Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing at all.Everything is just amazing Review collected by and hosted on G2.com.

Ronny D.

Analytics Engineer

Mid-Market (51-1000 emp.)

3/5/2023

"The default (and best) option"

5/5

What do you like best about PostgreSQL?

The upsides of using PostgreSQL include its reliability, scalability, advanced features, open-source nature, and strong community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Potential difficulties with setup and configuration, complexity that may not be necessary for smaller projects, challenging documentation, and potentially limited third-party integrations. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Regarding business problems, PostgreSQL can help us to manage our data, which is becoming increasingly important in today's data-driven world.

It can also help us ensure data consistency and accuracy.

Furthermore, its scalability and ability to handle large amounts of data make it well-suited for applications that require high availability and performance. Review collected by and hosted on G2.com.

Categories on G2

Relational Databases

Explore More

Top platforms for managing employee vacation and sick leave

Affordable session replay services for medium-sized ecommerce sites

Top platforms for managing employee vacation and sick leave

Affordable session replay services for medium-sized ecommerce sites

Writeup

Best marketing analytics solutions for SMBs

Pros and Cons Details

4.4 out of 5 stars

PostgreSQL Pros and Cons: Top Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Top Pros or Advantages of PostgreSQL

1. Features

2. Ease of Use

3. Scalability

4. Reliability

5. Open Source

6. Flexibility

7. Easy Integrations

8. Customer Support

9. User Interface

Top Cons or Disadvantages of PostgreSQL

1. Beginner Unfriendliness

2. Complexity

3. Learning Curve

4. Difficult Learning

5. High Hardware Requirements

6. Slow Performance

7. Data Management

8. Feature Limitations

9. Performance Issues

Top-Rated Alternatives

PostgreSQL Reviews (665)

PostgreSQL Reviews (665)

Filter Reviews

Categories on G2

Explore More