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

637 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.
637 PostgreSQL Reviews
4.4 out of 5
637 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.
Harsh P.
HP
SDE2
Information Services
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I like the UI of it. The security part is amazing. I really loved the product, and I am continuously using it in day-to-day work, also Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing at all.Everything is just amazing Review collected by and hosted on G2.com.

Ronny D.
RD
Analytics Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 Gives Campaign
Incentivized Review
What do you like best about PostgreSQL?

The upsides of using PostgreSQL include its reliability, scalability, advanced features, open-source nature, and strong community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Potential difficulties with setup and configuration, complexity that may not be necessary for smaller projects, challenging documentation, and potentially limited third-party integrations. Review collected by and hosted on G2.com.

Ansu A.
AA
Data Analyst
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic Review from User Profile
What do you like best about PostgreSQL?

The language used is universal to most query tools which makes it an easy tool to use and experiment. And learning ina free environment is super helpful Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Drag and drop of data values in not available in the latest version, as this feature is available in other editors this was expected and would have been helpful Review collected by and hosted on G2.com.

Divyarajsinh  C.
DC
Junior Software Engineer
Information Technology and Services
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 cost(minimal)

- Robust

- Scalability Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When I use some specific features, it gets stuck. Review collected by and hosted on G2.com.

Ayushi P.
AP
Analyst
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL, or "Postgres", is an open-source relational database management system (RDBMS).PostgreSQL, or "Postgres", is an open source relational database management system (RDBMS). It supports multiple programming languages, making it easy to develop applications using your preferred language. Unlike some other popular database solutions, such as MySQL and Microsoft SQL Server, PostgreSQL is 100% free and open source. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

One major disadvantage of PostgreSQL is that it doesn't enjoy as much support from software companies as other database systems like Microsoft SQL Server and Oracle. This can mean that you may find it difficult to find commercial software that supports PostgreSQL and that integrates well with your existing system. Another issue with PostgreSQL is that it can be difficult to upgrade to newer versions. If your company relies on upgrading its database system regularly in order to stay competitive, then you may not want to choose PostgreSQL.Finally, some businesses may find that they need more features than what's offered byPostgreSQL when compared to other enterprise-level database systems. These features may include complex security controls, data replication and mirroring, and advanced performance tuning options. Review collected by and hosted on G2.com.

Amir R.
AR
Engineering Manager
Financial Services
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

It is a flexible, fast RDBMS, with a lot of features Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is nothing wrong with this databased server. Review collected by and hosted on G2.com.

Farhan S.
FS
Software 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?

PostgreSQL is a fast, secure and reliable database to store relational data. It also supports ACID properties, so we stored sensitive data there. It is a open source platform so that we don't have to buy any subscription to use this database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL is not suitable for using JSON-like data structures. Also, it's not always available to every server; you must install it explicitly. PostgreSQL has a relatively slow query speed as compared to MySQL database. Review collected by and hosted on G2.com.

vijay b.
VB
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?

PostgreSQL is an Open Source Database that is used for mainly Relational database Systems. We are mainly using this database because of the microservice structure. And in microservices, we have a lot of databases and also it's open source so that is good for our organization. And it's an object-relational database the performance of the database is pretty good. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The documentation of PostgreSQL is not great. For beginners, it will be complex. and the second thing is the interface of PostgreSQL is not great. Review collected by and hosted on G2.com.

Pulkit G.
PG
Software Developer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

It has a good viewing App in which you can see all your schemas, tables, sequences, and many more. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is a bit difficult to integrate at the start. Review collected by and hosted on G2.com.

Shoaib T.
ST
Data Scientist
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 part is that it is free to use and open-source. The installation was super easy because there are plenty of guides available online. We have been using this to gather tweets, and it has made our job easier. Not only that, but it is user-friendly. It also allows for scalability, which is a bonus. As tweets are saved in json it is easier to go through them without anything crashing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is just one teeny issue and that is when you are trying to configure it, there can be some errors which can't be fixed. I was unable to find the solution till I Googled it and found it on a tech website which explained how to sort it out. This configuration issue occurred a year ago and it has yet to be fixed in the new release. Review collected by and hosted on G2.com.