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.
Sumanth S.
SS
Senior Technical Support Specialist
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Installation and setting up.

Running queries,

Ease of use with backup and restoration Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing as such. It's pretty good for common use cases. Review collected by and hosted on G2.com.

Or N.
ON
Data Engineer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Fast, lean has all the functions you need to work with a DB. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Everything is working fine so far. if there will be a change I will update Review collected by and hosted on G2.com.

Swetank S.
SS
Lead Associate
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

Best thing is its very easy to use and its training and support is easily available as one SQL language works same for almost all databases. If we know the tool well then sql knowledge is not much required. Also knolwedge of sql can be used in any databases. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

This tool is not used by many people which makes it hard to share file or databases with others. Compared to ssms its not have that much features and creating keys are also hard. Review collected by and hosted on G2.com.

Nitesh K.
NK
Project Associate(II)
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?

PostgreSQL is a Secure, robust, and reliable database. It is an open-source RDBMS having great performance to handle a large amount of data. PostgreSQL can be installed on windows as well as Linux operating systems. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL requires training for the beginner. It is managed by using a graphical tool through PgAdmin. Sometimes it is a little bit slow on executing queries on a large database. Installing PostgreSQL should be more User-friendly. Review collected by and hosted on G2.com.

Yash C.
YC
Software Engineer
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?

The thing which I like the most about PostgreSQL is it supports a wider variety of data types as compared to the others and it is also completely free to use and it also supports data warehousing Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The thing which I like the most about PostgreSQL is it is slower while reading the data from the database compared to others. Review collected by and hosted on G2.com.

Mashmuma Q.
MQ
Lead Data Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

PostgreSQL is a good option as an object-related database since it's free it is very convenient for us to request management to use it. One can use it for data storage and analysis both. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some features are missing which we can find in other database systems.

If I compare MYSQL and PostgreSQL in terms of optimization help through explain plan than MYSQL provides a more readable way than Postgre, after reading the MYSQL plan one can change its query to optimize it very easily while it's a bit difficult in Postgre explain plan. Review collected by and hosted on G2.com.

Abhishek J.
AJ
Jr. Full Stack Developer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is a regional database management system which stores the structure data.

Query execution speed is fast which helps to make over-all performance of the application fast.

Backups and restoration process is very easy.

It is secure, reliable and robust. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it takes lot of time to execute complex quries.

Installation process is little heavy as compare to other SQL databases.

User interface can be improved. Review collected by and hosted on G2.com.

Manu V.
MV
Senoir Software Developer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The thing I like most about PostgreSQL is that it has a dedicated database connection for all the fremwork. PostgreSQL has a reliable dependency for spring boot. It makes it easy to connect PostgreSQL to the backend and perform various operations through coding. When you compare it with other alternatives, it offers many features and, most importantly, provides up-to-date security. One more thing I like about PostgreSQL is its large support community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

To perform database-related tasks, you must have proper knowledge of PostgreSQL documentation. For fresher, it will be challenging to understand complex things in the documentation. One thing I noticed while using PostgreSQL was it becomes slow while handling huge transactions. Review collected by and hosted on G2.com.

Oscar C.
OC
Software Engineer
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?

How robust is postgres and how extensible it is. Despite being a database with lots of years in the market, it is up to date with the latest needs (for instance working with JSON data) Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing. Maybe the fact that mysql gets more popularity despite not being as robust as postgres Review collected by and hosted on G2.com.

Kushal V.
KV
Senior System Engineer - BI 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?

Easy to build connection between postgreSql to other framework. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I feel the interface could be better. It took little time to open pgadmin. Review collected by and hosted on G2.com.