Best thing is its very easy to use and its training and support is easily available as one SQL language works same for almost all databases. If we know the tool well then sql knowledge is not much required. Also knolwedge of sql can be used in any databases. Review collected by and hosted on G2.com.
This tool is not used by many people which makes it hard to share file or databases with others. Compared to ssms its not have that much features and creating keys are also hard. Review collected by and hosted on G2.com.
PostgreSQL is a Secure, robust, and reliable database. It is an open-source RDBMS having great performance to handle a large amount of data. PostgreSQL can be installed on windows as well as Linux operating systems. Review collected by and hosted on G2.com.
PostgreSQL requires training for the beginner. It is managed by using a graphical tool through PgAdmin. Sometimes it is a little bit slow on executing queries on a large database. Installing PostgreSQL should be more User-friendly. Review collected by and hosted on G2.com.
The thing which I like the most about PostgreSQL is it supports a wider variety of data types as compared to the others and it is also completely free to use and it also supports data warehousing Review collected by and hosted on G2.com.
The thing which I like the most about PostgreSQL is it is slower while reading the data from the database compared to others. Review collected by and hosted on G2.com.
PostgreSQL is a good option as an object-related database since it's free it is very convenient for us to request management to use it. One can use it for data storage and analysis both. Review collected by and hosted on G2.com.
Some features are missing which we can find in other database systems.
If I compare MYSQL and PostgreSQL in terms of optimization help through explain plan than MYSQL provides a more readable way than Postgre, after reading the MYSQL plan one can change its query to optimize it very easily while it's a bit difficult in Postgre explain plan. Review collected by and hosted on G2.com.
PostgreSQL is a regional database management system which stores the structure data.
Query execution speed is fast which helps to make over-all performance of the application fast.
Backups and restoration process is very easy.
It is secure, reliable and robust. Review collected by and hosted on G2.com.
Sometimes it takes lot of time to execute complex quries.
Installation process is little heavy as compare to other SQL databases.
User interface can be improved. Review collected by and hosted on G2.com.
The thing I like most about PostgreSQL is that it has a dedicated database connection for all the fremwork. PostgreSQL has a reliable dependency for spring boot. It makes it easy to connect PostgreSQL to the backend and perform various operations through coding. When you compare it with other alternatives, it offers many features and, most importantly, provides up-to-date security. One more thing I like about PostgreSQL is its large support community. Review collected by and hosted on G2.com.
To perform database-related tasks, you must have proper knowledge of PostgreSQL documentation. For fresher, it will be challenging to understand complex things in the documentation. One thing I noticed while using PostgreSQL was it becomes slow while handling huge transactions. Review collected by and hosted on G2.com.
How robust is postgres and how extensible it is. Despite being a database with lots of years in the market, it is up to date with the latest needs (for instance working with JSON data) Review collected by and hosted on G2.com.
Nothing. Maybe the fact that mysql gets more popularity despite not being as robust as postgres Review collected by and hosted on G2.com.
--> Open Source Nature
--> Easy to use and well-defined documentation and lots of tutorials for quick and fast learning
--> Comparable with Oracle Database System
--> Almost all features are available freely. You do not need any other database system if you use postgres. Review collected by and hosted on G2.com.
Absolute beginners can feel difficulty learning and implementing it in real-time projects. Basic knowledge of database management systems is a must to learn any DBMS Software. Review collected by and hosted on G2.com.