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.
Stanislas J.
SJ
Administrateur du SIGB
Libraries
Mid-Market (51-1000 emp.)
"Good DBMS"
What do you like best about PostgreSQL?

Very fast for running queries from bash or within PGAdmin ; ability to lauch queries from PHP Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Using variables in not as simple as in MySQL. I prefer PgAdmin 3 rather than PgAdmin 4. Review collected by and hosted on G2.com.

Ryne L.
RL
Account Manager
Mid-Market (51-1000 emp.)
"PostgreSQL"
What do you like best about PostgreSQL?

Functionality and organization of data is clean and concise Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

installing the application/software can be challenging for newer/less-experienced users. Review collected by and hosted on G2.com.

SN
Student Assistant
Hospital & Health Care
Small-Business (50 or fewer emp.)
"Great interface "
What do you like best about PostgreSQL?

This database allow us to interface the databases in a nice GUI that will interact with the database inside. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The GUI was a little slow and took a long time to run script to generate data. Review collected by and hosted on G2.com.

Verified User in International Affairs
UI
Small-Business (50 or fewer emp.)
"The opensource standard for SQL databases"
What do you like best about PostgreSQL?

I've been using PostgreSQL for many years, and although there are alternatives, I've found that for most use cases PostgreSQL is the RDBMS to go for.

It's not only because of its simplicity or its features. The main reason is that it is tuned to most workloads and you don't have to fine-tune or play with configuration files a lot: it simply works.

This really feels like the developers put a lot of care when designing the RDBMS engine and when choosing defaults. I still have to find a workload PostgreSQL is not suited for. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

This is not a complain, as I'm okay with the command line and fine using and configuring it through SSH in my servers, but a lot of colleagues find it difficult to do this. Most of them, accustomed to point-and-click solutions, or more mainstream databases, find it difficult to make the switch. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
CI
Mid-Market (51-1000 emp.)
"Database for the new age "
What do you like best about PostgreSQL?

Performance almost at par if not better than some of the commercial products out in the market. Supports a broad array of data types out of box. Open Source. Strong developer community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Might suffer in speed especially if the queries are not well written. (Unforgiving in general, which might be a good thing). Generic Error Messages Review collected by and hosted on G2.com.

Jemal M.
JM
Software Quality Assurance Engineer
Computer Software
Mid-Market (51-1000 emp.)
"PostgreSQL"
What do you like best about PostgreSQL?

Easy to use,good online support community,open source and available as a docker image Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Very strict on syntaxing and debugging not easy Review collected by and hosted on G2.com.

Verified User in Retail
AR
Mid-Market (51-1000 emp.)
"An easy, reliable, embeddable database engine"
What do you like best about PostgreSQL?

Simplicity and how easy it was to set up. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The product is lacking some features that are norm these days for a database engine. Review collected by and hosted on G2.com.

Cédric T.
CT
Cofounder, CTO and software developer
Internet
Small-Business (50 or fewer emp.)
"Easy to use relational database"
What do you like best about PostgreSQL?

user interface and commands are easy and comprehensive. It is well integrated into every application for web, mobile etc... Most useful database system for lots of data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much. Some times I forget about the commands in terminal Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising
AM
Small-Business (50 or fewer emp.)
"It handles millions of data efficiently and has a good Query performance."
What do you like best about PostgreSQL?

Cross platform

Designed for high volume of data.

Never crashes and is at no charge.which is the best thing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not great to interact with web applications. Review collected by and hosted on G2.com.

Nag T.
NT
Senior Software Engineer
Enterprise (> 1000 emp.)
"PostgreSQL Review"
What do you like best about PostgreSQL?

I love PostgreSQL than any other Databases Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

for beginners (new to Database) Installation and configuration is a bit difficult 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