PostgreSQL Pros and Cons

What do you like best about PostgreSQL?

Installation and setting up.

Running queries,

Ease of use with backup and restoration Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing as such. It's pretty good for common use cases. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Fast, lean has all the functions you need to work with a DB. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Everything is working fine so far. if there will be a change I will update Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

Nothing. Maybe the fact that mysql gets more popularity despite not being as robust as postgres Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Easy to build connection between postgreSql to other framework. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I feel the interface could be better. It took little time to open pgadmin. Review collected by and hosted on G2.com.