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.
Sumit G.
SG
Programmer
Enterprise (> 1000 emp.)
"Manage data easily with complex "
What do you like best about PostgreSQL?

Opensource relational database which can handle workloads from singlr machine applications to webservices Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Complex code to achieve big project and generic errors come while codinv Review collected by and hosted on G2.com.

Suraj P.
SP
Software engineer
Enterprise (> 1000 emp.)
"PostgreSQL"
What do you like best about PostgreSQL?

It is easy to use, Data management is good Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Integration with other application is little bit complicated. Review collected by and hosted on G2.com.

Jason M.
JM
Network Administrator
Information Technology and Services
Small-Business (50 or fewer emp.)
"Solid Database"
What do you like best about PostgreSQL?

I love how you can do everything from command line. I love not having to click around to find things inside of the program Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The only downside i have found is maybe not quite as much info as other databases. Review collected by and hosted on G2.com.

Joancel C.
JC
Software Developer
Small-Business (50 or fewer emp.)
" A great database manager without license costs."
What do you like best about PostgreSQL?

is a free software, available for the most used operating systems (Windows, macOS, Linux).

The graphical tool PgAdmin is easy and intuitive,i can manage, interact and manipulate different databases easily.

You can use it in read-only mode, with this option we can do maintenance or recovery without completely blocking the system. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It doesn't have official online support, although there is a lot of information in forums.

the syntax for some complex queries is a little complicated if you don't have knowledge in SQL language.

The installation and configuration of PostgreSQL is not so easy. Review collected by and hosted on G2.com.

Alessander V.
AV
Software Engineer
Computer Software
Enterprise (> 1000 emp.)
"One of the bests open source DBs"
What do you like best about PostgreSQL?

It's a powerful, reliable and fast relational database. It's open source and it's also object oriented. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Replication is hard to set up. The schema visibility among different users is a difficult too. Review collected by and hosted on G2.com.

Verified User in Electrical/Electronic Manufacturing
UE
Enterprise (> 1000 emp.)
"postgres is rock solid"
What do you like best about PostgreSQL?

rock solid database, proven , reliable and lost of features Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

single master, needs clustering like other databases Review collected by and hosted on G2.com.

Nidhi M.
NM
Information Technology Analyst
Information Technology and Services
Enterprise (> 1000 emp.)
"Good software for RDBMS"
What do you like best about PostgreSQL?

Open-source relational database management system emphasizing extensibility and standards compliance Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Wierd errors coming while connecting with python Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Pure Gold asObject RDBMS"
What do you like best about PostgreSQL?

Highly efficient in relaibility,data integrity.

Supports multiple OS.

Supports heavy duty indexing.

Supports performnace optimization.

Advanced data types like multi demensional arrays

Provides Horizontal scaling.

Provides data domain objects.

Provides access controls like brute force protection ,audit, enterprise directory compatibility, resource limit, security certification etc Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Earlier there was the scalability limitations which were then resolved. Review collected by and hosted on G2.com.

Colton J.
CJ
Junior Network Administrator
Information Technology and Services
Small-Business (50 or fewer emp.)
"A Great Solution To Improve Your Company"
What do you like best about PostgreSQL?

I can neatly organize my work when using this product. I am constantly worried about falling behind if there’s not a personal assistant beside me like this program. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don’t have too many problems with this service. I have only used this product for a short amount of time. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Easy to setup and highly reliable for anything to do on reporting"
What do you like best about PostgreSQL?

Extremely easy to setup, and very reliable for reporting applications. I use it on the AWS Cloud and pretty happy with the performance and maintainability. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

This may not be suitable for large scale data operation and storage. 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 analytics app is best for SaaS companies
Auto dialer service top picks
Most popular sales enablement solution
Which analytics app is best for SaaS companies
Auto dialer service top picks
Most popular sales enablement solution
What's the best SAP provider for company software needs
Award-winning performance management software for software companies
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