Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Editedit
PostgreSQL
Save to My Lists
Claimed
Claimed
This profile has been claimed by PostgreSQL, but it has limited features.
Do you work at PostgreSQL? Upgrade your plan to update branding and connect with profile visitors!

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

RaimaDB
Visit WebsiteNew Tab
SponsoredYou’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
MySQL
(1,636)
4.4 out of 5
See all PostgreSQL Alternatives

638 PostgreSQL Reviews

4.4 out of 5
View 2 Video 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.
  • Company SizeExpand/Collapse Company Size Filter
  • User RoleExpand/Collapse User Role Filter
  • CategoryExpand/Collapse Category Filter
  • IndustryExpand/Collapse Industry Filter
  • RegionExpand/Collapse Region Filter
The next elements are filters and will change the displayed results once they are selected.
  • Sort By:
    G2 Sort
638 PostgreSQL Reviews
4.4 out of 5
  • Sort By:
    G2 Sort
638 PostgreSQL Reviews
4.4 out of 5
  • Sort By:
    G2 Sort

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.
Here's how.
Rickert M.
RM
Software Developer
Information Technology and Services
Small-Business (50 or fewer emp.)
"Awesome open source database"
What do you like best about PostgreSQL?

I love the large feature set built into Postgres. In particular, range queries are a godsend for time-based applications. Full-text search functionality means I don't have to bother with an elastic search installation. There is also much additional functionality that can be gained via extensions such as postgis. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Replication can be a pain to configure compared to other DBs. Hosted solutions like RDS takes care of this though. Review collected by and hosted on G2.com.

Zhanbolat A.
ZA
Application Development Engineer
Internet
Enterprise (> 1000 emp.)
"Excellent DB for enterprises"
What do you like best about PostgreSQL?

The software can be extended. I like its compatibility with different OSs. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

UI could be improved to make it more user friendly Review collected by and hosted on G2.com.

Verified User in Computer Software
IC
Enterprise (> 1000 emp.)
"Great tool for relation DB"
What do you like best about PostgreSQL?

Great tool for relational database with additional functionality then sql Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some of the query are not as same as sql. It would be nice to make it same language Review collected by and hosted on G2.com.

Verified User in Financial Services
UF
Small-Business (50 or fewer emp.)
"Free cant go wrong!"
What do you like best about PostgreSQL?

Vacuum feature is the best. Reasonably fast for medium enterprise development. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Could get really challenging with a huge data deployment and multi data center deployment. Review collected by and hosted on G2.com.

Pascaline I.
PI
R&D intern
Computer Software
Mid-Market (51-1000 emp.)
"Postgresql documentation are clear and is a friendly database."
What do you like best about PostgreSQL?

It is very easy to create scripts.Moreover, it provides users with more functionalities. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it took long to connect to the database. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Easily Manageable RDBS "
What do you like best about PostgreSQL?

CTEs – Common Table Expressions - which allow us to do awesome things like recursive queries but even the most simple form of them. A nice feature that we can easily achive Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its replication was implemented at the storage engine level, that makes it bit expensive interms of reoplication Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
II
Mid-Market (51-1000 emp.)
"Free to use"
What do you like best about PostgreSQL?

I use the free version and like the fact that it provides almost all the relational features like oracle db Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Required a bit of learning to adjust and its always good to include that in your timeline Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Postgres sql "
What do you like best about PostgreSQL?

It’s very cost effective and it has extension to GIS which is great. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It does not have AWR report that is helpful in finding all queries that are getting executed . Also when you delete lot of record it create vacuum . Review collected by and hosted on G2.com.

Verified User in Non-Profit Organization Management
AN
Small-Business (50 or fewer emp.)
"PostgreSQL review!"
What do you like best about PostgreSQL?

Great tool for both learning and production! No major issues, straightforward and easy to use. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I can't think of anything in particular that I did not like. You really need to know what you are doing to use this product, but that's about it. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Small-Business (50 or fewer emp.)
"Good database"
What do you like best about PostgreSQL?

I like how it has tables and also how it has columns Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't like how there are no good clients that let you see images directly in the viewer Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
View More Pricing Information
Categories on G2
Relational Databases
Explore More
What's the most recommended partner relationship management software
What are the best practices for using a data room in corporate legal teams?
Top rated cloud storage and collaboration tools
What's the most recommended partner relationship management software
What are the best practices for using a data room in corporate legal teams?
Top rated cloud storage and collaboration tools
Most recommended business travel management software
best digital signage software
Pros and Cons Details

PostgreSQL Comparisons

Compare PostgreSQL vs. MySQL
Compare PostgreSQL vs. MySQL
PostgreSQLVSMySQL
Compare PostgreSQL vs. MariaDB
Compare PostgreSQL vs. MariaDB
PostgreSQLVSMariaDB
Compare Oracle Database vs. PostgreSQL
Compare Oracle Database vs. PostgreSQL
PostgreSQLVSOracle Database
Compare PostgreSQL ratings to similar products
PostgreSQL