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.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

2/1/2024

"Great database"

4.5/5

What do you like best about PostgreSQL?

Is the best database to store the geom polygons Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The sintaxes from some functions are not easy to understand Review collected by and hosted on G2.com.

Ayush G.

Small-Business (50 or fewer emp.)

7/5/2023

"Postgres: Flexible SQL/NOSQL Database"

4.5/5

What do you like best about PostgreSQL?

-It has the ability to store NOSQL data as well such as JSON

-Well suited when data is transactional as well as informative

-Free to use

-Postgres's ORM is available For almost all major programming language

-Installation is very straightforward

-Easy to maintain compared to other SQL databases Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

-Not as fast as MySQL

-Without ORM, Query writing can be tedious and slow

-As it supports JSON schema as well it can be difficult to manage at scale

-Horizontal scaling can be trickier to achieve Review collected by and hosted on G2.com.

Ankit A.

Senior Technical Consultant Database

Enterprise (> 1000 emp.)

2/10/2023

"Best open source relational database for geo location and data migration"

3.5/5

What do you like best about PostgreSQL?

What I like most about PostgreSQL is its open source. Being an open-source relational database, it also provides value to the customer and their users in terms of fast and internal precalculated libraries and functions that help developers and users retrieve data fastly without any hurdle.

Postgresql is also helping us with fast query execution and efficient use of memory. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Being an open-source relational database, the area of improvement is its inability to handle large-volume database application support.

Another thing is its limited community or ecosystem compared to premium databases like oracle and SQL servers.

The query execution explanation plan is also not good in PostgreSQL.

Postgresql does not have any run-time debugger, so some time to hard to find the error's root cause. Review collected by and hosted on G2.com.

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

Postgresql provides a relational database system that is helping startups and developers to learn databases and adopt new technologies that can't pay licensing fees.

It helped me to generate a geo-tagging platform that required a fast and accurate lat-long calculation that couldn't be completed without the PostgreSQL / PostGIS.

Postgresql helped me to learn how we could integrate json with RDBMS. Review collected by and hosted on G2.com.

Kartik B.

Software Trainee

Mid-Market (51-1000 emp.)

9/10/2023

"Data Mangement system"

5/5

What do you like best about PostgreSQL?

I have used this software for Blog Platform Management. It was very helpful & easy to manage data. It provide easier & userfriendly queries to all users. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Integrating with framework it is very time consuming. Review collected by and hosted on G2.com.

Verified User in Computer Software

Enterprise (> 1000 emp.)

8/28/2023

"Postgres - Open source RDBMS solution"

4.5/5

What do you like best about PostgreSQL?

The PostgreSQL relational database is a open source database system - which is free to use, easily configurable and carry overs all the basic SQL principles and Syntax. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is a downside of the PostgreSQL that it is not able to handle multiple idle connections, it loses the ability for new connections to reconnect. If that can be fixed, it's awesome. Review collected by and hosted on G2.com.

Mohit S.

Mid-Market (51-1000 emp.)

9/1/2023

"Best open source database to achieve high performance and scalability."

4.5/5

What do you like best about PostgreSQL?

It is a open source application and allows to scale whenever needed. It is very fast and secure to manipulate data. Database creation, updation is very easy in PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Learning PostgreSQL is challenging in beginning because it is complex and documentation is not that much easy to understand. The documentation should have examples for reference. Review collected by and hosted on G2.com.

Jasmeet K.

Data Scientist

Mid-Market (51-1000 emp.)

4/20/2023

"Excellent RDBMS for production systems with minimal cost."

5/5

What do you like best about PostgreSQL?

I have used Postgres SQL extensively for the past few years and it is few of cost effective scalable RDBMS that runs very smooth with web applications specially with Django backend. This RDBMS can be tuned for performance quickly and offers amazing support for custom functions.

This RDBMS can be scaled quickly and is available in cloud services like Amazon RDS which can make this database manageable. The error messages in the RDBMS is very clearly laid out and I just love the way it provides flexibility of using custom SQL workbenches. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I have loved my experience with Postgres SQL and the user community for this RDBMS is amazing. I have faced issues in reading documentation for Postgres but online community has always helped in getting my issues resolved. Review collected by and hosted on G2.com.

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

PostgresSQL has been a goto database management system in our projects because of its flexiblity and seamless integration with Django. I have been using PostgresSQL extensively for data storage and analysis. This RDBMS is really cost effective and we use it in Amazon RDS for production instance. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

1/1/2024

"Great database system to use for beginners."

4/5

What do you like best about PostgreSQL?

Very reliable tool to use and easy to understand plus its consistent and also adapts to changing infrastructure in the market. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The documentation is very dense which is nit easy to understand by beginners. Review collected by and hosted on G2.com.

Kwabena A. B.

IT Professional

Mid-Market (51-1000 emp.)

5/11/2023

"Enterprise Open Source Relational Database Management System"

5/5

What do you like best about PostgreSQL?

PostgresSQL shines as an enterprise RDBMS. It has all the enterprise features of a modern database management system, yet it is free and open source. It can handle a data intensive system very well. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is really difficult to talk about any dislike about PostgreSQL, however it has a bit of a learning curve. Also, installation and configuration on a linux platform is a bit complicated. Review collected by and hosted on G2.com.

Ramiro L.

Small-Business (50 or fewer emp.)

5/25/2023

"Feature-rich, and performant database system that suits a wide range of applications"

5/5

What do you like best about PostgreSQL?

-Scalability and Performance: PostgreSQL can handle high-volume workloads and scale to large datasets.

-Cross-Platform Compatibility: PostgreSQL runs on multiple platforms, including Linux, macOS, and Windows. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

-Configuration and Performance Tuning: Optimizing performance in PostgreSQL can be challenging, particularly for complex workloads and large datasets.

-Upgrade Process: Upgrading PostgreSQL to newer versions may require careful planning and testing, as it involves migrating data and ensuring compatibility with existing applications and extensions. Review collected by and hosted on G2.com.

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

PostgreSQL solves several problems in the realm of data management:

-Data Integrity and ACID Compliance: PostgreSQL implements ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring data integrity and reliability.

-Data Integration and Interoperability: PostgreSQL supports integration with other systems and tools.

-Scalability and Performance: PostgreSQL offers scalability and handles high-volume workloads effectively. Review collected by and hosted on G2.com.