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.
Kelvin S.
KS
Data Analyst - ETL Data Migration
Information Technology and Services
Small-Business (50 or fewer emp.)
"Postgre SQL review from Sipeyiye Intelligence Pty"
What do you like best about PostgreSQL?

it has the easiest database interface which is very user-friendly with proper query return space Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

it does not have the feature of table or schema prediction, makes it laborious and time-consuming typing a search Review collected by and hosted on G2.com.

Nikhil J.
NJ
Associate Team Lead
Enterprise (> 1000 emp.)
"Semi-structured data handling is awesome"
What do you like best about PostgreSQL?

I like the techniques as in SQL we can't store the Json and all but here storing the whole Json was a big advantage instead of writing all the fields to database Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The UI is little clumsy as I have used in linux through dbeaver Review collected by and hosted on G2.com.

Verified User in Financial Services
UF
Enterprise (> 1000 emp.)
"Great industry standard"
What do you like best about PostgreSQL?

It is an industry standard especially for database management in large scale application. Works quite easily Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not as customizable as MySQL and no covering index support Review collected by and hosted on G2.com.

Vishnu P.
VP
Sr. Cloud Consultant
Small-Business (50 or fewer emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Best for storing ecommerce data"
What do you like best about PostgreSQL?

PostgreSQL is simple is having the lowest learning curve and it's lightweight too. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It requires much more resources to execute when there are multiple queries running. Review collected by and hosted on G2.com.

Verified User in Transportation/Trucking/Railroad
UT
Enterprise (> 1000 emp.)
"It's all right but not my favorite application"
What do you like best about PostgreSQL?

Is very useful for our edi applications in terms of efficiency Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The syntax feels a little redundant and tends to be a lot pickier than some others Review collected by and hosted on G2.com.

EW
IT Project Manager
Mid-Market (51-1000 emp.)
"PostgreSQL is very Effective in data strorage and retrival of information"
What do you like best about PostgreSQL?

The simplicity in the software, it detects IP addresses automatically without manual configurations which can be hectic to the technician. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it gets disconnected to the database and one has to configure it a fresh in order to collect information from the database. Review collected by and hosted on G2.com.

Verified User in Accounting
CA
Mid-Market (51-1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Best Postgresql"
What do you like best about PostgreSQL?

I love this engine, I have worked with this database since 2010 and always have new features, open source, great forum and if you need additional features you have other tools based in this code Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Many people think that is a difficult database because documentation is not friendly, technical concepts that not all can understand immediately Review collected by and hosted on G2.com.

Alexandra G.
AG
AVP of Cyber Security Data Science
Mid-Market (51-1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Reliable and easy to use"
What do you like best about PostgreSQL?

Installation and integration with my work environment was easy. I use it often. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I honestly have no complaints. I love how easy the controls are to find. Review collected by and hosted on G2.com.

Verified User in Transportation/Trucking/Railroad
AT
Small-Business (50 or fewer emp.)
"the power of strict rules"
What do you like best about PostgreSQL?

the strictness of the system allows for better security, while the features let us make the tables work as we desire. And all of that using SQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much to be honest. Maybe how hard it was to make it work at first. Or the fact that permissions are directly wiped with the tables. Which may be for the better. Review collected by and hosted on G2.com.

Verified User in Banking
CB
Enterprise (> 1000 emp.)
"Open source post relational database"
What do you like best about PostgreSQL?

Open source, easy installation and read to use. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Hard to hand code error and does not support sql syntex 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
Which is the best app for hosting virtual events
best customer success software
Help me pick the best time tracking software
Which is the best app for hosting virtual events
best customer success software
Help me pick the best time tracking software
Best Anti Money Laundering Software
Most user-friendly CRM for sales teams
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