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.
Marco P.
MP
Co-founder / CTO
Small-Business (50 or fewer emp.)
"Performant, reliable and scalable"
What do you like best about PostgreSQL?

We use PostgreSQL in production since 8 years now, in a multi-nodes HA setup based on the built-in streaming replication. PostgreSQL is a great database, offering high performances and allowing to easily scale read-replicas with the built-in streaming replication. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The major issue with PostgreSQL is the complexity of doing a major version upgrade with nearly zero downtime. Starting from PostgreSQL 10 this issue has been largely reduce thanks to the logical replication. Review collected by and hosted on G2.com.

Arturo J.
AJ
Director de Tecnología
Computer Software
Small-Business (50 or fewer emp.)
"Great database for cloud software"
What do you like best about PostgreSQL?

PostgreSQL is a great database for cloud development Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Documentation is a nit tricky to understand at first Review collected by and hosted on G2.com.

Manjushri S.
MS
Java Software Developer
Information Technology and Services
Enterprise (> 1000 emp.)
"PostgreSQL database review"
What do you like best about PostgreSQL?

PostgreSQL is an open source database and in that way has a great advantage over other licensed databases like Oracle. Currently, we have been trying to migrate all legacy applications from Oracle to postGRESQL.PostgreSQL database works very well with hibernate JPA and we have been using it extensive along with the Spring framework. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is no good client to use the database been using pg admin and I am not really a big fan of the interface provided by pgadmin, we cannot "pin" any query results unlike the SQL developer. Review collected by and hosted on G2.com.

Justin H.
JH
Carrier Sales / Switch Technician
Telecommunications
Small-Business (50 or fewer emp.)
"PostgreSQL usually gets the job done"
What do you like best about PostgreSQL?

Data integrity, wide variety of column types, great documentation Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Data import can be difficult, usually needs a 3rd party tool even with the simplest CSV files. Review collected by and hosted on G2.com.

Sorabh S.
SS
Head Of Development
Enterprise (> 1000 emp.)
"Best for Any medium scale sized project"
What do you like best about PostgreSQL?

ANSI Compliant SQL, Verbose logging, Replication ease, Indexing performance Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing as such , would recommend for further projects also. Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Small-Business (50 or fewer emp.)
"Postgres is the best"
What do you like best about PostgreSQL?

Fast secure frequently updated and plenty of drivers available. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not as popular as some other solutions so which can make it hard to debug strange errrs Review collected by and hosted on G2.com.

Verified User in Higher Education
UH
Enterprise (> 1000 emp.)
"Great Versatile DBMS software"
What do you like best about PostgreSQL?

The ability to create databases without any price requirement and allowing to run SWL commands on those databases dynamically is great Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is no GUI to check the created databases and their values for a quick glance. Review collected by and hosted on G2.com.

Verified User in Higher Education
UH
Enterprise (> 1000 emp.)
"Great database system"
What do you like best about PostgreSQL?

I enjoyed the capability to use other programming languages within it to allow for easy data modifications and more. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The thing that was the hardest to get comfortable with was all the short hand notation. Most are single character, which can get confusing. Review collected by and hosted on G2.com.

Verified User in Insurance
UI
Enterprise (> 1000 emp.)
"Fantastic Database for all use cases"
What do you like best about PostgreSQL?

It's free, and I can install it on any of my VMs and make it work for me. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing in particular. There isn't enough on Stackoverflow for this product as compare to Oracle. Review collected by and hosted on G2.com.

Verified User in Telecommunications
UT
Mid-Market (51-1000 emp.)
"PostgreSQL, the best fusion between SQL and programming"
What do you like best about PostgreSQL?

The immense possibility of programming allowed by the code, allowing the generation of interfaces from SQL code. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

None, it is a very good alternative to the fusion of any programming language that works with SQL. 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
PostgreSQL Comparisons
Product Avatar Image
MySQL
Compare Now
Product Avatar Image
MariaDB
Compare Now
Product Avatar Image
Oracle Database
Compare Now
PostgreSQL Features
Storage
Availability
Stability
Text Search
Data Types
Operating Systems
Database Locking
Access Control
Data Concurrency
View More Features
Categories on G2
Relational Databases
Explore More
Where to find reliable partner relationship management tools
Leading software for media analysis
Best customer service software for my tech company
Where to find reliable partner relationship management tools
Leading software for media analysis
Best customer service software for my tech company
Leading third-party risk management software
Best operational risk tools for app developers
Pros and Cons Details
PostgreSQL