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.
Verified User in Computer Software
AC
Small-Business (50 or fewer emp.)
"Good database "
What do you like best about PostgreSQL?

I have been using postgresql for 8 years as a lead developer. We prefer it over MySQL Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

What I dislike is that it can be difficult to set up as a local environment. Review collected by and hosted on G2.com.

Soumyajit P.
SP
Data Scientist
Oil & Energy
Small-Business (50 or fewer emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Best SQL Query tool in the market"
What do you like best about PostgreSQL?

The ease of data base management system. Its simple user dashboard and quick cloud response time. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing specific dislikes. Sometime there are server errors. You could have a review on that. Review collected by and hosted on G2.com.

Verified User in Automotive
UA
Mid-Market (51-1000 emp.)
"Lightweight and Open Source"
What do you like best about PostgreSQL?

PostGreSQL is easy to implement and administer and is self sustaining for large databases. It's open source so a big cost savings compared to Oracle or SQL Server Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Performance is not optimal on low latency disks Review collected by and hosted on G2.com.

Verified User in Food & Beverages
IF
Mid-Market (51-1000 emp.)
"Easy to use"
What do you like best about PostgreSQL?

Easy to use and inline with most of the sql databases architecture Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I would like to see it support multiple IDE’S Review collected by and hosted on G2.com.

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

Easy to setup and good option to be used as a metastore. Available in heroku. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Configuring in windows machine is not as simple as MacOS or Linux bases systems. Review collected by and hosted on G2.com.

Verified User in Telecommunications
AT
Enterprise (> 1000 emp.)
"Advanced than other SQL"
What do you like best about PostgreSQL?

PostgreSQL is easy to install and with analytic functions. It supports IP address datatype such as inet, checks constraint and uses programming language for stored procedures such as Python, JS, Perl.

Moreover, it allows indexes also allowing Full Outer Join. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The process of installing is just a bit goofy and not documentation is not lined up for clarity even though it's not a difficult process. Review collected by and hosted on G2.com.

Paul Giancarlo D.
PD
Programmer Analyst Equifax
Mid-Market (51-1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Psql Rules"
What do you like best about PostgreSQL?

I like postgres, i used for many implementations and works like a charm. You need few minutes for install. So you start work really fast with postgres. Console likes me too, have all the things you need. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I think nothing. In my experience you cant used for multiplatform i mean when you use with windows and Linux have to lead with Upper/Less table names. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Enterprise (> 1000 emp.)
"Postgres Review"
What do you like best about PostgreSQL?

It's an incredible comprehensive software that doesn't have the same ACID problems as mysql Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Well sometimes its hard to find a stable UI for the platform Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Enterprise (> 1000 emp.)
"Review for PostgreSQL"
What do you like best about PostgreSQL?

I like that when in work my colleagues and I are able to handle large amounts of data on the networks,we have been able to scale and customize the best path for our needs to improve our performance. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes slow in certain area and no support that I'm aware of Review collected by and hosted on G2.com.

Verified User in Education Management
UE
Enterprise (> 1000 emp.)
"easy way of aggregating databases"
What do you like best about PostgreSQL?

syntax is straightforward and easy to pick up on Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

can be somewhat difficult to install initially 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
digital adoption platforms
Best multi-country payroll software for small business
Which company offers the most reliable AI infrastructure tools
digital adoption platforms
Best multi-country payroll software for small business
Which company offers the most reliable AI infrastructure tools
What is the best software for handling sales rep commissions
What specific industry compliance standards (e.g., ISO 27001, SOC 2, HIPAA, GDPR, FedRAMP) does JumpCloud MDM adhere to and provide certifications for?
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