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.
Prashil N.
PN
Research Assistant - Machine Learning and Advanced Visualisation
Higher Education
Mid-Market (51-1000 emp.)
"User friendly "
What do you like best about PostgreSQL?

I like the fact that it works seamlessly. No added learning is required. Any experience with other SQL tools and you can pick up PostgreSQL in a few days. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I have experienced problems of PostgreSQL hanging for huge data queries. Review collected by and hosted on G2.com.

Verified User in Computer Networking
UC
Mid-Market (51-1000 emp.)
"Good opensource tool"
What do you like best about PostgreSQL?

Postgre SQL is a good open source tool to handle large amounts of data. It is cheaper compared to other tools available in the market. The installation process is very fast and smooth. Easier to integrate with a variety of ETL tools such as Informatica. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The free version has a lot of restrictions with security control and speed. We wanted to test this tool before we get a paid service but could not explore more in the free version. Review collected by and hosted on G2.com.

Verified User in Computer & Network Security
UC
Mid-Market (51-1000 emp.)
"It has an excellent graphic manager."
What do you like best about PostgreSQL?

Being able to handle queries in the graphical environment is always more comfortable and pleasant to work with. PostgreSQL has the advantage of having a very large community, which is always advantageous to have different references to lean on if needed. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is one of the most popular and always a good option, but is not thinking for companies with robust systems. But it will always be a good option to consider. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
Mid-Market (51-1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"My PostgreSQL Review"
What do you like best about PostgreSQL?

its free to implenting in your system and easy to setup. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

the collation configurantion because they causes some problems in many frameworks. Review collected by and hosted on G2.com.

Verified User in Transportation/Trucking/Railroad
AT
Mid-Market (51-1000 emp.)
"Great opensource database server"
What do you like best about PostgreSQL?

It is a really simple and powerful relational datababase server. It is free!! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The installation process is very hard task to do. You need advanced linux knowledge to install and implement it. Review collected by and hosted on G2.com.

CA
Solutions Architect
Enterprise (> 1000 emp.)
"Great Database"
What do you like best about PostgreSQL?

Ease to implement and rock solid performance Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

New features are not released immediately to the open community Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Small-Business (50 or fewer emp.)
"PostgreSQL robust open source database"
What do you like best about PostgreSQL?

The best part of offloading data storage tasks to PostgreSQL is the robustness of the database system, which is equal to any of the commercial systems. The expressiveness of the PostgreSQL is no less than that of commercial offerings, or even of experimental system for that matter. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The design seems fairly monolithic compared to newer designs, so the system has a fairly large footprint and there are few options to reduce it. A modular system might be more suitable for today's cloud servers which are extremely compact in size, and demand software that is highly optimized in memory consumption. Review collected by and hosted on G2.com.

Verified User in Computer Software
CC
Enterprise (> 1000 emp.)
"Best DB in market"
What do you like best about PostgreSQL?

Postures is tool that it can be integrated with customized software till now. Has best functionality ease to use Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postures service dies once centos OS Or Helios restart. Please look into this matter as soon as possible Review collected by and hosted on G2.com.

Verified User in Telecommunications
AT
Enterprise (> 1000 emp.)
"PostgresSQL review from DBA point of view"
What do you like best about PostgreSQL?

Postgresql is very light weight and easy to install . So as a DBA it is also simple to maintain. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgresql can not scale horizontally like Oracle DB. Review collected by and hosted on G2.com.

Sai Sabarish K.
SK
Senior Software Engineer
Enterprise (> 1000 emp.)
"My postgresql"
What do you like best about PostgreSQL?

Its relational plus no sql style with full json support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not completely no sql still has realtional touch. 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
Leading third-party risk management software
Top-rated sales performance tools in the software sector
Best email marketing software for small business
Leading third-party risk management software
Top-rated sales performance tools in the software sector
Best email marketing software for small business
Best conversation intelligence software
Best sales app for improving team performance
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