Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

PostgreSQL Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users find PostgreSQL's ease of use exceptional, praising its user-friendly interface and straightforward setup. (14 mentions)
Users appreciate the robustness and feature-rich capabilities of PostgreSQL, highlighting its extensibility and community support. (8 mentions)
Users appreciate the open source nature of PostgreSQL, enhancing accessibility and flexibility for various applications. (7 mentions)
Users value the exceptional customer support of PostgreSQL, benefiting from its robust community and extensive features. (4 mentions)
Users value the easy integrations of PostgreSQL, simplifying their development process with seamless cloud connectivity and user-friendly tools. (4 mentions)
Users find PostgreSQL beginner-unfriendly, as its complex documentation makes initial usage challenging for newcomers. (7 mentions)
Users find the difficult learning curve of PostgreSQL challenging, especially during initial setup and feature understanding. (5 mentions)
Users experience slow performance with PostgreSQL, particularly during large data queries and when importing CSV files. (5 mentions)
Users find feature limitations in PostgreSQL, noting fewer configuration options and GUI tools compared to competitors. (3 mentions)
Users find the initial setup complexity of PostgreSQL challenging, especially for newcomers, despite its powerful features. (2 mentions)

Top Rated PostgreSQL Alternatives

MySQL
(1,636)
4.4 out of 5

638 PostgreSQL Reviews

The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
638 PostgreSQL Reviews
4.4 out of 5
638 PostgreSQL Reviews
4.4 out of 5

PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
Krishna Prasad J.
KJ
Talend Developer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

--> Open Source Nature

--> Easy to use and well-defined documentation and lots of tutorials for quick and fast learning

--> Comparable with Oracle Database System

--> Almost all features are available freely. You do not need any other database system if you use postgres. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Absolute beginners can feel difficulty learning and implementing it in real-time projects. Basic knowledge of database management systems is a must to learn any DBMS Software. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

PostgreSQL is one of the best relational databases. It supports multiple data types and has good query and data management support. The documentation is maintained and is the best place to learn everything about the database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL supports JSON datatype but the supporting methods are difficult to understand and work with. The documentation is present but there aren't enough examples that would help developers understand and use the methods. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care
UH
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It is an open-source relational database that supports a heavy range of workloads. it follows the ACID properties and SQL queries. PostgreSQL has views, tables, store procedures etc. The database can connect with multiple interfaces and supports python, java, C++, PHP and perl. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It has a slow Comparatively low reading speed. Its documentation is only available in English. In some circumstances, the lack of columnar stores renders PostgreSQL less capable in analytics tasks. Review collected by and hosted on G2.com.

Verified User in Chemicals
UC
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

Compared to MySQL, PostgreSQL is quicker and provides ACID characteristics. Storage procs can be created in PL/pgSQL, PL/Python, PL/Perl, and C/C++, and it has broader community support. It is a highly expandable database that handles large datasets, challenging queries, and read-write operations more quickly. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Only limited documentation is available in English. Additionally, the reading speed is really slow. PostgreSQL is one of the best open-source databases available besides this. Review collected by and hosted on G2.com.

Saurabh K.
SK
Software Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgresSQL has very clean UI and very simple to use. Anyone can open multiple tabs. Developer can write custom queries in it. It is unique sql software for developers. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgresSQL sql is not very famous and it is not used by many companies. But it deserves to be part of every company. PostgresSQL can more work on its UI. So that it would be competitive in the market. Review collected by and hosted on G2.com.

Sakchi .
S
Intern
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The best thing i liked about PostgreSQL is that it's very easy to use and can handle various complex queries. It is also helpful when you need to run huge queries such as trigger. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

As such there is no dislike about PostgreSQL but yes, for a beginner who have no or less Knowledge about SQL, it will be very difficult for him/her to work on PostgreSQL. Review collected by and hosted on G2.com.

Raj P.
RP
Software Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

This is the most versatile and advanced DB system in the market available for free of cost. This DB system is similar to MySQL or Oracle DB system but it is more popular and has a bigger community than those. It has a convenient command-line interface for both Linux and Windows OS. It has intuitive commands that do what they sound like e.g., create table, create database, etc. For those who are not good with command-line interfaces, it also has GUI based management tool called pgAdmin for easier use. It has easy integration with Python and Golang and its frameworks like Django for Python. You can easily export table data in CSV. The best thing is, it has a detailed documentation website where you can explore all of its functionalities easily and release-wise. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Honestly, I don't think this RDBMS has any significant flaw or issue. One thing is, there are fewer drivers available for this database for integration in frameworks e.g. Python Django framework literally has one driver called psycopg2 which can create license issues. Another thing is, it has a huge number of commands that can be difficult for some people to grasp. Review collected by and hosted on G2.com.

Jean-Marie R.
JR
Open Source Database Technical leader
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Rating Updated ()
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

SQL standards

Stable configuration settings per version

Improvments over time

A lot of tools around PostgreSQL: as pgAdmin4, programmaing language connectors, pgbadger, pgbackrest, patroni, ...

PostgreSQL is an Open source piece of software. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

A lot of different projets around PostgreSQL himself for same purpose.

No full featured and supported clustering solution embedded natively.

Long new features development cycle. Review collected by and hosted on G2.com.

Priya B.
PB
Senior Software Engineer| Business Intelligence Developer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

Postgresql is a flexible relational database solution for transactional/statistical data and can also be used as a NoSQL solution. Postgresql has the best capabilities for handling spatial data. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgresql database management system requires expertise and has certain limitations using it in the cloud. Also, cost and time are the two biggest challenges to be aware of when adopting this database. Review collected by and hosted on G2.com.

Tabassum K.
TK
Senior Data Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I liked this database because of easily schema control and very robust to setting the process, it is also less risky and hard to break out the security layers. Features like multi-inversion concurrency control help in fluid changes to be made to the system. data management is also very easy. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

As such no disadvantages at all but we need to take care of so many things at the time of implementation. It could be improved by using parallization and need distributed computing. Review collected by and hosted on G2.com.