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.
Aditya B.
AB
Data Engineer
Small-Business (50 or fewer emp.)
"PostgreSQL: Excellent OLTP Performance, Fast Single-Query Speeds"
What do you like best about PostgreSQL?

PostgreSQL is one of the best OLTP databases available. Its greatest strength is its fast single-query performance. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I find the SQL syntax used in the PostgreSQL CLI to be quite confusing, especially when compared to MySQL, which relies on more straightforward SQL commands for querying in its command-line interface as well. Review collected by and hosted on G2.com.

AK
Member Technical Staff
Computer Software
Small-Business (50 or fewer emp.)
"i am using this as my database since 2024 i love this product"
What do you like best about PostgreSQL?

we can automatically create a ER diagram of a databse with 2-3 clicks . its very easy install in my system the storage was very low and easy to integrate i use it frequently in a day . we can easily create delete and edit the tables, views etc . i mostly like the User Interface of this product. there is also a sql query writing screen which is very much useful in getting customized results and some basic views can be get by selecting the table button options it self. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

when starting the pgadmin loading time was too long it takes upto 1 min to open Review collected by and hosted on G2.com.

Blas C.
BC
Software Engineer
Mid-Market (51-1000 emp.)
"Powerful relational database easy to integrate"
What do you like best 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. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes depending on the query the syntax is a little bit complex Review collected by and hosted on G2.com.

Aravinth V.
AV
Technical Lead
Mid-Market (51-1000 emp.)
"Good SQL Database to handle the Relational DataBase"
What do you like best about PostgreSQL?

It is best to handle the RDBMS and it guarantees the Data Integrity using ACID property Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It will use more resources like Memory and CPU compare to other DB Review collected by and hosted on G2.com.

Arvind T.
AT
Technical Leader
Mid-Market (51-1000 emp.)
"Great Functionality, but Long Queries Can Slow Down the Database"
What do you like best about PostgreSQL?

Support many functionalities like spatial database. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Swapnil Patel i.
SI
Product Engineer
Enterprise (> 1000 emp.)
"High Data integrity and complex query support with various data types choose postgres sql only"
What do you like best about PostgreSQL?

We can play with many data types and we are in fintech domain so it is quite efficient in term of banking. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometime i need analytical processing then i lag somehow with postgre sql. Review collected by and hosted on G2.com.

Dhiraj D.
DD
Data Engineer
Enterprise (> 1000 emp.)
"Best DB workbench"
What do you like best about PostgreSQL?

It's user interface is very friendly. It easily give data modification table , schema , views create scripts. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it's crashes when we run heavy queries Review collected by and hosted on G2.com.

PS
intern
Mid-Market (51-1000 emp.)
"great software experience"
What do you like best about PostgreSQL?

NO LISCENCE COST, EASY TO HANDLE, FULL SUPPORTSFOR JOINS ,PROCEDURES AND WINDOW FUNCTIONS Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

HEAVY WORKLOAD, SLOWER WRITE PERFORMANCE Review collected by and hosted on G2.com.

Duvan Dario D.
DD
Data Engineer
Mid-Market (51-1000 emp.)
"very good database, a bit complicated user management"
What do you like best about PostgreSQL?

special features and integrations Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

role management and permission management for users Review collected by and hosted on G2.com.

Verified User in Accounting
UA
Small-Business (50 or fewer emp.)
"PostgreSQL:"
What do you like best about PostgreSQL?

Strong support for advanced indexing techniques like BRIN, GIN, and GiST, which optimize query performance for large datasets. Plus, its built-in JSON support makes it an excellent choice for handling semi-structured data without sacrificing relational capabilities. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Replication and clustering can be more manual compared to solutions like MySQL’s built-in replication Review collected by and hosted on G2.com.

Product Avatar Image
PostgreSQL
View Alternatives