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 appreciate the rich feature set of PostgreSQL, which supports flexibility and complex SQL queries seamlessly. (14 mentions)

Users appreciate the ease of use of PostgreSQL, praising its user-friendly interface and seamless integration with various tools. (11 mentions)

Users value the scalability of PostgreSQL, which adapts effortlessly to both small and large application demands. (9 mentions)

Users commend the exceptional reliability of PostgreSQL, appreciating its ACID compliance and robust concurrency control. (8 mentions)

Users value PostgreSQL for its open-source benefits, providing powerful features at no cost while maintaining reliability. (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, with a steep learning curve and complex configurations for newcomers. (7 mentions)

Users find the complexity of SQL syntax in PostgreSQL confusing, especially compared to simpler alternatives like MySQL. (5 mentions)

Users find the steeper learning curve of PostgreSQL challenging, especially for beginners unfamiliar with advanced configurations. (5 mentions)

Users find the difficult learning curve of PostgreSQL challenging, especially for beginners tackling advanced features. (4 mentions)

Users note the high hardware requirements of PostgreSQL, which can strain system resources, especially at scale. (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 appreciate the rich feature set of PostgreSQL, which supports flexibility and complex SQL queries seamlessly.

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 appreciate the ease of use of PostgreSQL, praising its user-friendly interface and seamless integration with various tools.

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, which adapts effortlessly to both small and large application demands.

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 commend the exceptional reliability of PostgreSQL, appreciating its ACID compliance and robust concurrency control.

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 PostgreSQL for its open-source benefits, providing powerful features at no cost while maintaining reliability.

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, with a steep learning curve and complex configurations for newcomers.

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 complexity of SQL syntax in PostgreSQL confusing, especially compared to simpler 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 the steeper learning curve of PostgreSQL challenging, especially for beginners unfamiliar with advanced configurations.

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 the difficult learning curve of PostgreSQL challenging, especially for beginners tackling advanced features.

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, which can strain system resources, especially at scale.

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 (663)

View 2 Video Reviews

G2 reviews are authentic and verified.

Here's how.

Diego G.

Engineering Lead

Mid-Market (51-1000 emp.)

11/22/2024

"Simply an amazing tool"

5/5

What do you like best about PostgreSQL?

It's very powerful and versatile, and has a huge ecosystem built around it. It's the de-facto solution for so many problems nowadays. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not about PostgreSQL itself, but the fact that the major cloud providers don't keep well enough with all the latest developments Review collected by and hosted on G2.com.

NAYAN K.

Data Scientist

Mid-Market (51-1000 emp.)

7/26/2024

"PostgreSQL: Most popular SQL DBMS Software"

5/5

What do you like best 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 connect with Python with ease. I use it frequently for my day to day RDBMS use. Canbe easily integrated with python. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There should be some more extensions with widely used open source software/apps. Review collected by and hosted on G2.com.

CHIRADEEP B.

Associate Technology

Enterprise (> 1000 emp.)

5/18/2024

"Integrating Cube analytics in Postgresql"

5/5

What do you like best about PostgreSQL?

Very easy to use and set up

PostgreSQL comes with a very easy to use UI ( User Interface ) tool like PG-Admin for every client to connect & Interact with the database.

PG Admin is very easy to use & setup with just a mouse click unlike other traditional RDBMS .

I highly recommend PostgreSQL for every client to connect & Interact, apart from MYSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing as such, sometimes query execution get delayed but that is very rare.

Overally its a very light-weight & user friendly tool for ervery client who want to connect with the database seamlessly.

I Review collected by and hosted on G2.com.

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

It enables me to check transcation count of every user, enables all trigger , procedures, function and other PL/SQL operation seamlessly.

It also helps to perform and execute multiple joins operation in the event of requirement of data from multiple table to retrieve the result.

Postgresql also enables aggregate function( MIN, MAX, AVG, COUNT, SUM, AVG) and views, cursor, Index. Review collected by and hosted on G2.com.

Ashwini B.

Software Developer

Small-Business (50 or fewer emp.)

4/23/2024

"PostgreSQL : user review"

5/5

What do you like best about PostgreSQL?

PostgreSQL is easy to use in daily development life. Developer can easily implement and integrate it into system by using gem postgres. It has different versions for operating system. It is open source relational database model and i can use it in operating system like window , ubuntu, mac ect. Most of the developer use it frequently. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When i execute large data query or complex query application stop responding. It has enormous number of users so customer support may take time to resolve query. Review collected by and hosted on G2.com.

Aavinashh L.

Manager Dashboards and Business Intelligence

Enterprise (> 1000 emp.)

10/13/2024

"PostgreSQL is robust database to rely on."

4.5/5

What do you like best about PostgreSQL?

Its wonderful DBMS that has wide range of extentions and relaibiility features with great customer support Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It has one feature that needs improvement on resources useage as it uses lots of your system resources. Review collected by and hosted on G2.com.

Rodrigo A.

Media Activation Manager

Mid-Market (51-1000 emp.)

9/27/2024

"It has the most intuitive UI"

4.5/5

What do you like best about PostgreSQL?

It's super easy to understand, implement, and adapt to any data lake. PostgreSQL has implemented many features to facilitate joint and data selections Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I can't complain about anything about postgreSQL Review collected by and hosted on G2.com.

madhusudan rao y.

Vice President Of Engineering

Small-Business (50 or fewer emp.)

9/14/2023

"Powerful Open Source RDBMS"

4.5/5

What do you like best about PostgreSQL?

Open Source database with a very active and passionate community.

Supports SQL and enterprise applications.

One of the best relational databases around that can be used to support various multimedia.

Very fast and able to provide access based user logins to the database Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Initial setup is not straightforward.

Getting through the very customizable options is difficult if you are just starting out. Not an easy task for a beginner to start with.

Limited GUI tools. Puts off many new users who are just starting on this journey as most of the new programmers are more habituated to a visual interface. Review collected by and hosted on G2.com.

Antonio H.

Consultor y CTO

Enterprise (> 1000 emp.)

3/27/2024

"Better than non-free RDMBS"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL allows us to manage our Dashboards generated using OLAP cubes with amazing speed and reliability. Also, its possibility of using it in Cluster format provides us with a lot of value, guaranteeing accessibility and availability of data, as well as backup copies. The beauty of this software is in the simplicity. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Very few systems can compare with PostgreSQL in my opinion (and integrated with PostGIS, it is great!). But it is true that payment systems such as SQL Server or Oracle have more configuration options, which can be useful for advanced installations. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

1/18/2024

"PostgreSQL : Top Open Source RDBMS Choice"

4.5/5

What do you like best about PostgreSQL?

Its best thing is , it is open source.

Other things i like about postgreSQL is its vast range of Data Types like JSON, Arrays, Custom data types, custom functions and operators. It gives good flexiblity.

It can handle huge amount of data, high traffic loads.

It is suitable for both large and small scale applications.

I love its command line interface.

It is easy to setup.

It can be integrated everywhere.

As it has large and active community it provides regular updates and bug fixes. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

As it has wide range of feature it may take some time to learn for beginners.

Its UI tool is not that user-friendly, I rarely use it.

1 Feature they can have is distributed computing. Review collected by and hosted on G2.com.

Subrat P.

Project Engineer

Mid-Market (51-1000 emp.)

1/29/2024

"Postgresql :- A New Trendy Relational and Open source database management tool"

4.5/5

What do you like best about PostgreSQL?

Postgresql is very easy to use in its pgAdmin and also in other enterprise application like DBeaver. I most like about its connectivety with clouds like AWS's RDS service etc. Best relational and open source database in term of easy to use, database recovery, backup, maintenance and its connectivety. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For beginners its initial setup complexity or the learning curve for advanced features and it's configurations little bit hard because its initial setup is not straightforword specially its port availibilty. Some user may get confused with icons of Postgresql because it may differ from MySQL, Oracle. Review collected by and hosted on G2.com.

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

PostgreSQL addresses various database challenges, offering benefits like scalability like table partitioning and built-in replication , open-source , flexibility that supports various data types , indexing methods, and procedural languages . Users find it valuable for their applications, enabling them to manage data effectively and reliably. Review collected by and hosted on G2.com.