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

By PostgreSQL

4.4 out of 5 stars

How would you rate your experience with PostgreSQL?

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.
Verified User in Computer Software
AC
Mid-Market (51-1000 emp.)
"PostgreSQL : Top Open Source RDBMS Choice"
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.
SP
Project Engineer
Mid-Market (51-1000 emp.)
"Postgresql :- A New Trendy Relational and Open source database management tool"
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.

NG
Business analyst
Small-Business (50 or fewer emp.)
"PostgreSQL is very help for me to find the Accurate data"
What do you like best about PostgreSQL?

PostgreSQL is very easy to use and eady to implementation but i can use cusotmer support of this tools its very frquent to use any person can easy learn and very fast way lots of features available in PostgreSQL like how to import data in very easy way and very easy to integration also customer support might be good not sure about this. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It will take some time to open and import data from CSV file Review collected by and hosted on G2.com.

RR
Manager
Information Technology and Services
Small-Business (50 or fewer emp.)
"PostgreSQL gives you more flexibility in data types, scalability, concurrency, and data integrity."
What do you like best about PostgreSQL?

PostgreSQL offers a powerful GIS extension called "PostGIS" that provides hundreds of functions for processing geometric data. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL may have slower performance than other RDBMS like SQL Server and MySQL. Review collected by and hosted on G2.com.

ANUJ R.
AR
Technical Lead
Small-Business (50 or fewer emp.)
"Review related to postgresql"
What do you like best about PostgreSQL?

Best RDBMS tool in the market. Its simple to install, configure and use. It support sql language do DDL DML operations , which supports both OLAP and OLTP workload Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing I felt. Everything is simple and easy. Review collected by and hosted on G2.com.

Vaibhav K.
VK
Associate Software Engineer
Mid-Market (51-1000 emp.)
"One of the best database"
What do you like best about PostgreSQL?

If you are finding databases alternatives to use with your env then postgresql is one of the best choice i can say.

Because it provides a robust and powerful architecture. Anybody want to start to have the knowledge of databases then i can say use the postgresql so that you will have the lots of think clear in your mind and also by passing sometime you definetily love the postgresql database. Quering to postgresql is very much simple and anybody can understand. there are lot to add but you should use postgresql. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes launching pg admin takes sometime. Review collected by and hosted on G2.com.

Henry C.
HC
Mid-Market (51-1000 emp.)
"A great open source database"
What do you like best about PostgreSQL?

I think it is really well documented, you can find lots of free tutorials en webpages and youtube. You can configure it to fit your requirements.

It also has a lot of functionalities, I think it is one of the most advanced databases available right now.

You can integrate PostgreSQL with a lot of different tools, and it provides great advantages for your use. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It can be a little tricky for starters, because the inital configuration can be a little cumbersome, but I think it is not a big deal since you have support online where you can find a lot of tutorials. Review collected by and hosted on G2.com.

Shwetank S.
SS
Software Engineer
Mid-Market (51-1000 emp.)
"PostgreSQL: The world's most advanced open source database"
What do you like best about PostgreSQL?

postgresql is highly secured.it has SSL certificates for encrypted connections which tells us how secure is it. you can give the accesss basd on role and define the custom rules.i like the perfomance of it in terms of how fast it is it provides you the facilities like indexing, query optimisation etc. so performance wise its beating its competitors in the market. its reliable and stable many companies use this in the production which tells us the trust of companies on its security aspects.its easy to use as a beginner anyone can understand it easily. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

its setp and configurations are little bit complex.when you will trigger big queries it occupies larges space so its kind of resource intensive so you may see sometimes performance scaling becomes the major concern. Review collected by and hosted on G2.com.

Rohit M.
RM
Cloud Analyst
Mid-Market (51-1000 emp.)
"Awesome Relational Database management tool!"
What do you like best about PostgreSQL?

PostgreSQL is a great open source Relational database managent tool,it supports Query langueage which is way similar to famous SQL languages that means if anybody have ever worked on SQL then moving onto the PostgreSQL wont take much efforts.it supports all the major data types used in database processing and also gives security related features like role based access and authentication which is the most important feature because it is going to store the confidential information. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

i have used postgreSQL locally and over a cloud enviroment, the setup was easy on cloud enviroment but i was continuesly facing a issue for very long time, it was throwing me out of the current session for no reason, i was not able to identify the root cause of this problem but this is something any user wont want to face when he is working on database or storage related tool. locally i have found no issue at all. Review collected by and hosted on G2.com.

Shree P.
SP
Small-Business (50 or fewer emp.)
"Unveiling the Power and versatility of an open source database solution"
What do you like best about PostgreSQL?

PostgreSQL impresses with its robustness, ACID Compliance , and extensibility . Its commitment to standards, comprehensive documentation and strong community support contribute to a reliable and feature rich database management system .

The flexibility to handle diverse data types and advanced indexing capabilities further solidify postgreSQL standing as a top choice for data driven applications Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

While postgreSQL is feature-rich,its initial setup complexity can be a drawback for newcomers. Additionally, certain performances optimizations may require fine tuning , demanding a deeper nuances, the benifits often outweigh these challenges in the long run Review collected by and hosted on G2.com.

Product Avatar Image
PostgreSQL
View Alternatives