PostgreSQL Pros and Cons

What do you like best about PostgreSQL?

PostgreSQL is the best option to make developments with high amounts of data management volume and sentences. This is a database that serves applications perfectly, it is easy to use when it is integrated with tools such as EnterpriseDB and the security provided by Postgres is a very strong value. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you use postgres by console and not with any graphical tool such as pgadmin or dbeaver you must have intermediate knowledge, you may notice some slowness in massive insertions but this is related to the good design of the database Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

This database is extremely tunable and runs very well inside of a container Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

pg.conf should be driven by a common markdown language Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Features in Postgres are equivalent to Oracle RDBMS, although some of the features like JSON support were not present till Oracle 11g which is a part of PostgresSQL. Documentation is extensive and easily available. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PGAdmin can be made more user-friendly like search for specific keyword for existing database objects like table or function name which is not available. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

We prefer Postgres over any other database management system because it can be run on any platform and is very easy to program. It follows a good general sql format and has great JSON support. This is something we find very helpful because we needed a borderline NoSql like environment too. It is also open sourced, so it is easily accessible. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

My biggest issue with postgres is that it consumes a ridiculous amount of CPU cycles. If you want to compress data to deal with efficiency and speed, it is not possible. I would still prefer it over a database like sybase, because of its pros, but it is definitely heavy on the memory. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Multiple data amounts can be maintained for longer periods making persistence easier as the risk is that the data can be reloaded. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Degrade quality in contrast to Mysql when using SELECT, a standard car vacuum may be feasible. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

What I like most about Postgresql is that I can store and manage a database with large volumes of information, with excellent security and is very robust at the level of data processing. The base language is sql, which is very simple to manipulate and obtain information, and also can be installed both in windows, as in linux, as is my case, and its installation is very simple. Another of the things I like about postgresql is that there is a lot of documentation and tutorials to learn how to use the tool and the updates are periodic since they have the support of postgresql.org, which guarantees the postgresql update. Other aspects that I like about this application is that there is no lease charge since Postgresql is completely free for installation and use Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

What I do not like about Postgresql, is that its native interface for managing and manipulating data in tables is very rudimentary and is done through the console environment of the operating system. Therefore, a database client such as Pgadmin must be installed in order to have a pleasant data handling and manipulation environment. Another thing that I do not like about this application is that the process of inserting into small databases is very slow compared to other databases such as MYSQL. This is because Postgresql was designed to handle databases with large volumes of information. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

It's free. Done! The best of something is when you get what you want without paying, this is the case of PostgreSQL.

There will be a time when you need to create an application/software, and no matter if it will be used for 5 or 1000 users, different geographic locations, you will get an easy setup, strong documentation and a great community behind PostgreSQL.

Finally, it is a multi-platform software, so you can have multiple instances either in linux or windows, it comes down to your personal preference, personally, I always use Debian and I haven't ever had any big issue. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Replication process. Last time I checked, I had to use Slony or something outside PostgreSQL to accomplish this process. I would like that there would have been a way to do it native n the core of PostgreSQL.

Also, the documentation is really strong, you will find it quick and easy and in a really neat way, but I would like that it was more easy to read, maybe it's just me, but I like for example the way ReactJS documentation is made, I believe that it gives you a clear idea without using weird and rare words. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

I use Postgresql as my favorite data handler above MySql, Oracle among others, due to its simple way of use and what I like most is that it is totally cross platform I can install it on Linux and Windows without problems exporting a database and without problems being able to make a retore from any operating system

But one of the things that I like the most is that you can have a high concurrence in the access of the users who want to consult information in the database without any waiting or blocking to the other users and the answers of the queries are exact and updated to the latest modifications made to the records in an easy professional manner and with impressive stability Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

One of the things I do not like is the migration of versions with respect to databases and more than anything with stored procedures it is simply complicated when there is a new version sometimes it is very difficult to migrate from one version to another and less if the version is higher and I want to migrate a database to a lower version, I really dislike this since I have had to implement backups and create new procedures to raise the back of a database with its functionalities correctly in other versions and despite that there is a lot of documentation on the internet and many Postgres forums do not have an official help obviously for being free code Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

What I like most about PostgreSQL apart from how reliable and powerful this database manager is, is that it can be managed with other visual programs such as PgAdmin. This makes it possible to manage Posgrest visually, it is more convenient to easily use the SQL statements that through consoles this is what I like most of Postgres Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

one of the things that I dislike most of Postgres is that it is very complicated to pass a file in Excel with information to a table in Postgres since with mysqladmin it is much simpler and easier to do this procedure that in my work I have to do frequently this process in postgres in their new versions should make it easier for the user Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

PostgreSQL is one of the most interesting options in open-source relational databases.

PostgreSQL brings a lot of flexibility to our projects. For example, it allows us to define custom functions through various languages. Some of them are:

PL/pgSQL

PL/Tcl

PL/Perl

PL/Python

PL/PHP

PL/Ruby

PL/Java

One advantage of PostgreSQL is that it is available for many platforms and offers source code from the official site. Some of the official builds are:

Mac OS X

Windows

Solaris

Red Hat

Debian

Ubuntu Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Relatively slow on inserts and updates in small databases, PostgreSQL is designed for high-volume environments. This makes the response speed seem slow compared to small databases.

The syntax of some of your commands or statements may not be intuitive if you don't have an average level of knowledge of SQL language. Review collected by and hosted on G2.com.