Visit Website
Sponsored
Introducing G2.ai, the future of software buying.Try now
PostgreSQL
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!
Do you work at PostgreSQL? Upgrade your plan to update branding and connect with profile visitors!
PostgreSQL
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)
638 PostgreSQL Reviews
4.4 out of 5
View 2 Video ReviewsThe next elements are filters and will change the displayed results once they are selected.
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
G2 reviews are authentic and verified.
Here's how.
We strive to keep our reviews authentic.
G2 reviews are an important part of the buying process, and we understand the value they provide to both our customers and buyers. To ensure the value is retained, it's important to make certain that reviews are authentic and trustworthy, which is why G2 requires verified methods to write a review and validates the reviewer's identity before approving. G2 validates the reviewers identity with our moderation process that prevents inauthentic reviews, and we strive to collect reviews in a responsible and ethical manner.
ES
Ekta S.
Senior Software Developer
Mid-Market(51-1000 emp.)
What do you like best about PostgreSQL?
Easy to install and integrate with the application. It uses standard SQL and also supports object-oriented SQL programming and we can also perform JSON-based data transactions with this dbms. Client-Server network architecture support is the best thing is with Postgresql and of-course it is open source DBMS Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
Some speed issues with PostgreSQL when we perform data transactions on very large numbers. Backup features should be improved and PostgreSQL should provide some own GUI for DB operation, normally we use pgAdmin for the same purpose. Review collected by and hosted on G2.com.
AB
Aayush B.
Software Intern
Small-Business(50 or fewer emp.)
What do you like best about PostgreSQL?
It is very robust and easy to install and configure. there are large number of add ons which can be used in this database. Overall it is best db for a developer. Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
the queries which requires large calculations are very slow. Many a times i faced problem with the way its indexing work for a particular table in database which is headache for developers. Review collected by and hosted on G2.com.
RS
Rahul S.
Software Engineer
Mid-Market(51-1000 emp.)
What do you like best about PostgreSQL?
It is open source and support all SQL Operations. Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
I think there are not much to dislike about. Review collected by and hosted on G2.com.
AK
Akash K.
SDE-1
Small-Business(50 or fewer emp.)
What do you like best about PostgreSQL?
First of all it is open source and has dedicated database connections for all mostly used web frameworks, It also provides up to date security with newer updates and almost all features are free of cost Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
Speed issues with PostgreSQL performing data transactions on very large numbers.If you have worked with any other SQL, you will find PostgreSQL is similar to other SQL Review collected by and hosted on G2.com.
BM
Biswadeb M.
Application Development Senior Analyst
Mid-Market(51-1000 emp.)
What do you like best about PostgreSQL?
Open source, ready-made ide as PgAdmin tool, lightweight and easy to use Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
Faced alot of database crashing and hang issues despite configuring with runnable solutions. Review collected by and hosted on G2.com.
AJ
AMIT J.
Data Scientist L3
Small-Business(50 or fewer emp.)
What do you like best about PostgreSQL?
I have used PostgreSQL in one of my projects. Before that, I have not used postgresql. As per clients' requirements, we have to use the PostgreSQL database. So We learned it quickly Since I have worked with other SQL previously. And find it very easy to work with PostgreSQL. Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
If you have worked with any other SQL, you will find PostgreSQL is similar to other SQL also, but the main advantage is it is very convenient for structured data. Review collected by and hosted on G2.com.
SS
SHALABH S.
Senior Software Engineer
Enterprise(> 1000 emp.)
What do you like best about PostgreSQL?
Ability to use Json type columns which lets us use it like non - Relational dbs.
Also it's completely open source.
Good for students and freelancers Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
Difficulty to perform groupBy query on JSON type columns using SLICK.
Not enough documentation available for postgres using SLICK Review collected by and hosted on G2.com.
UC
Verified User in Computer Software
Enterprise(> 1000 emp.)
What do you like best about PostgreSQL?
Object relative, good expanding,nice features, open source and large community Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
Sometimes it takes more time, opensource it is a disadvantage at the same time Review collected by and hosted on G2.com.
HB
Haripriya B.
Summer Intern
Internet
Enterprise(> 1000 emp.)
Rating Updated ()
Original
What do you like best about PostgreSQL?
It is free and open DBMS software and has a good GUI feature. PostgreSQL is the world’s most advanced open source database. Developed over 25 years by a vibrant and independent open source community, PostgreSQL was born from the same research as Oracle and DB2 and contained comparable enterprise-class features such as full ACID compliance for outstanding transaction reliability and Multi-Version Concurrency Control for supporting high concurrent loads. On top of it, there is a vibrant community of PostgreSQL professionals and enthusiasts that your staff can draw upon and contribute to. Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
It sometimes crashed when I open it in normal mode. I need to open it in admin mode to open it. It is considerably slower than MySQL, and it does not support the entire ANSI SQL 92' standard, much less the ANSI SQL 99' standard, which is widely used in the industry. PostgreSQL is not good when it comes to performance, and It is not much popular than other database management systems, making replication is more complex. Review collected by and hosted on G2.com.
UI
Verified User in Information Technology and Services
Mid-Market(51-1000 emp.)
Rating Updated ()
Original
What do you like best about PostgreSQL?
Postgres database gives us more and more column fields that are very useful, like uuid and boolen, that other database doesn't provide. Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
It is very slow compare to other databases like Oracle, MySQL, etc. Review collected by and hosted on G2.com.
PostgreSQL Categories on G2
Explore More
Hunting for software insights?
With over 2.5 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
