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.
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.
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.
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.
Open source, ready-made ide as PgAdmin tool, lightweight and easy to use Review collected by and hosted on G2.com.
Faced alot of database crashing and hang issues despite configuring with runnable solutions. Review collected by and hosted on G2.com.
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.
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.
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.
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.
Object relative, good expanding,nice features, open source and large community Review collected by and hosted on G2.com.
Sometimes it takes more time, opensource it is a disadvantage at the same time Review collected by and hosted on G2.com.
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.
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.
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.
It is very slow compare to other databases like Oracle, MySQL, etc. Review collected by and hosted on G2.com.
It is completely free, easy to set up, extremely robust, and has great performances on concurrency, transactions, and schema. It is also well-supported so new features and improvements are rolled out frequently. Review collected by and hosted on G2.com.
For large-scale enterprise applications, PostgreSQL is slow. Horizontal scaling is difficult and a culprit. Could use improvements for JSON. Not a lot of online documentation and resources available compared to MySQL. Review collected by and hosted on G2.com.