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.
AS
Software developer
Small-Business (50 or fewer emp.)
"The most trusted database."
What do you like best about PostgreSQL?

Very robust. Fully ACID compliant. Can scale very well at high concurrency levels. Supports asynchronous and synchronous replication. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Because of it's complexity and power, using PostgreSQL might be killing too much in small applications that will not make use of it's full power. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Enterprise (> 1000 emp.)
"PostGreSQL awesome tool"
What do you like best about PostgreSQL?

Opening the database is very easy and simple, also the filter options are very simple for anyone with minimal explanation Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

i dont see anything that can be said as dislike, it does what is needed Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
Small-Business (50 or fewer emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"PostgreSQL is a feature rich open source database"
What do you like best about PostgreSQL?

No licensing! PostgreSQL offers many of the same features Oracle database but at no cost. Optional extensions (ggaudit, uuid-ossp, etc.) add to the numerous native features of the database. JSONB data types also allow for PostgreSQL to be used as a document store. PostgreSQL has it's pgplsql procedural language, plus the ability to use other languages such as Python. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There are some features which are not quiet as robust as Oracle. Oracle auditing is more granular. The lack of referential integrity for partitioned tables is a con. Review collected by and hosted on G2.com.

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

The huge library of functions make it easier for the user to implement his required functionality without writing custom queries. PostgreSQL used to lag when it comes to speed performance but now that it has updated it is fast enough. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Documentation and Example is not extensive. PHP my Admin tool is not very user friendly . I have personally used the phpMyAdmin and was disappointed . PHP Storms inbuilt database plugin is much better. Review collected by and hosted on G2.com.

Verified User in Entertainment
UE
Small-Business (50 or fewer emp.)
"Psql is more user-friendly "
What do you like best about PostgreSQL?

Compared to Oracle, Postrges seems to be more forgiving to first-time sql users. The statements allowed by Postgres are more logical and structured which really makes sense to most sql users when they first get started. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres has a lot of functions and packages that you can add to extend the core functionality, but those addons are usually hyped by web forms. It's usually not something that a non- db admin can do. Materialized views and time functions that are really helpful for marketing or data transference require someone who knows what they're doing, but those online articles don't make that clear. You'll really need to partner with a pro to make sure you get the most performant system while also adding any packages or functions. Review collected by and hosted on G2.com.

SJ
Senior Security Engineer
Small-Business (50 or fewer emp.)
"Powerful database with ease of use"
What do you like best about PostgreSQL?

Easy to understand how to stand up and configure. Lots of users providing online demonstrations on configuration and use. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not a lot of information if you are trying to secure communications between servers using SSL Review collected by and hosted on G2.com.

Jeffrey L.
JL
CEO
Computer Software
Small-Business (50 or fewer emp.)
"Open Source, Enterprise-ready Database"
What do you like best about PostgreSQL?

Rich support for SQL, real booleans, JSON in the schedule with query support, rich plugin library, solid performance and reliability. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing, really. As a SQL RDMS PostgreSQL is quite good. I suppose that Oracle has better support for very large databases and clustering, but PostgreSQL is good enough for 1000's of concurrent connections on a 14Gbyte DB. Review collected by and hosted on G2.com.

Lucian M.
LM
Owner, Affiliate Marketer, Social Media Specialist & Web Hosting Provider
Small-Business (50 or fewer emp.)
"Postgres - a great database for Canvas LMS"
What do you like best about PostgreSQL?

Scalable, stable, reliable database app, easy to use. It provides a strong platform to work with databases for different applications, including the LMS (learning management systems). PostgreSQL provides stability and performance for large projects also. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing major, needs good programming for efficiency. You can backup the database using the dump command, then you can restore different constructs and sections. Review collected by and hosted on G2.com.

LH
I am student
Mid-Market (51-1000 emp.)
"My experience"
What do you like best about PostgreSQL?

I like to do my sql queries in postgresql Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don’t dislike anything about it . It’s perfect and always help even though I don’t remember the code Review collected by and hosted on G2.com.

William G.
WG
Tech Resource
Enterprise (> 1000 emp.)
"Great product"
What do you like best about PostgreSQL?

The command line tools are very well developed! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

That it's not as popular as it should be. It really needs to dominate the market. 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
Best relational database software for tech startups
What are the best secure data room solutions for private equity
best customer communications management software
Best relational database software for tech startups
What are the best secure data room solutions for private equity
best customer communications management software
Contact center software with best reviews
What's the best app for managing corporate events
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