PostgreSQL Reviews

Excellent database manager, it has its own program (phAdmin) that gives you a very friendly graphical interface to carry out all kinds of tasks. Postgress is highly scalable and stable, which is why I prefer it over other options

As against, when the database that is handled is relatively small, when comparing response speeds with other engines, it has a small disadvantage, but its great advantage is noted by having a large database.

PostgreSQL is well supported by backend frameworks like Django. Getting into the command line of PostgreSQL database isn't necessary that often, but when a must, it works very robustly.

Not suitable for some data types as well as some of the competition, like time series data, that is becoming more and more important via IoT use cases.

its graphic environment and considerable savings in operating costs: PostgreSQL has been designed to have a maintenance and adjustment lower than the products of commercial suppliers, while retaining all the characteristics, stability and performance. Stability and reliability: There have been no drops in the database

That Compared to MySQL is slower in insertions and updates, since it has intersection headers that do not have MySQL Support online: There are official forums, but there is no mandatory help It consumes more resources than MySQL .

its compatibility with previous versions makes development very friendly.
It is also Open source and free, which allows saving costs in the development of systems.
there is a lot of documentation online to find solutions to problems In addition to having a large community

It's official handler is not friendly.
Installation for begginners is not easy.
configure advanced functions such as replication It is complicated

It is free although there are some paid options that include support and special configurations. It is very stable, I have not had any critical situations like data loss. As a ASP.NET developer, it integrates easy using ADO.NET Data Providers for which there are many choices. Concurrency control is included which is very useful for data integrity. Versions for Linux, Mac, Solaris and BSD are available which increases the integration power. A huge number of third party add-ons (paid and free) can be found. PostgreSQL is being continuously improving, there is a well defined plan of maintenance and new versions are coming out regularly.

I have not found anything against this DMBS product. I have accomplished all of my goals successfully.

It is very complete for any type of project or application.
It is stable, easy to use and can handle a lot of structured data.
It is free software and is very well documented
It is very popular and has a very varied community around the project

Its installation and configuration can be a bit complex at first.
Being free they are not obliged to provide support
Requires specific tuning for each possible scenario

It allows me to implement a robust database in a very short time, using a structure very similar to Oracle, in addition to having many tools that allow us to manage the data in the best way.

There are functionalities that with third-party products can obtain better results.

Cost saving was the main benefit. We switched for the cost saving and also to stay in synch with our vendor Ellucian.

The transition period was challenging. In particular, we needed to bring on a temporary staff member to help rewrite our 1000+ reports and dashboards from the Microsoft SQL Server language to PostgreSQL. We used the free (unrelated) tool from SQLines to help with this task: https://sqlines.com/sql-server-to-postgresql. I wish the PGAdmin software had a better built-in search feature, but otherwise it seems to have all the same functionality as SQL Server Management Studio.

- easy to install and configuration as a cluster;
- free of charge;
- performant, secure, and reliable in terms of high availability;
- runs under different platforms and has lots of connectors to be used with various languages and frameworks;
- has a great pgAdmin GUI tool for management;

- could be slow on inserts and updates even on not large tables;
- had compatibility issues in the past when migrating between different versions;
- no online support, sometimes information found on the web could be not relevant to the version you have;

- Postgres is just soooo reliable, it's hard to corrupt or lose data unless you go in and manually edit or delete the data.
- Battle-tested ACID transactions to make sure you only update the data when it makes sense to have saved me so much time.
- The SQL interface is easy to use once you've mastered SQL (which it isn't; it's the simplest of all the languages I've learned).
- Newer versions even has support for advanced use cases such as arrays and JSON objects.
- The best thing is that 90% of the backend software developers know Postgres (or MySQL which is pretty dang similar) so help is never too far away!

The only real reason to not use Postgres is that it is pretty hard to scale. If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize. Postgres provides poor support for identifying the queries that are running really slowly. e.g. you have to install a buggy plugin and then query a funky poorly documented table. Trying to do master-slave replication is also quite difficult as you often run into consistency issues and will have to modify app logic. In these cases, it's better to go with NoSQL obviously.

This is one of the best database software I’ve used. It has a lot of features/functions that are usable for Big projects. One of them I've use is the PSQL vector search that is not widely used but very important feature that built in PSQL, beside that it has a tons of usable functions to do operations inside database and then get the result for example timezone adjusting, manipulation with data, string function and etc.

Trully telling there should be few cons in this software. I've used this for over 4 years sometimes find to difficult to configure it it linux environments compared with mysql.

- Free code database manager, which is not used for licensing.
- Easy to install and configure in any operating system.
- Ideal for relational databases.
- It has a large community in which you can share doubts.
- It is stable and reliable, scalable and secure with the correct user management.
- Can work with small and large databases.
- Handles the SQL language.
- Being free software, it is compatible with several graphic tools that help administration and database design. I particularly recommend working with PgAdmin in its latest version for postgres 9.6.6 onwards.
- Easily works as a cluster, can be configured as active-passive or active-active which improves performance
- It allows to perform maintenance, recovery of databases.
- I have tested the installation and use in Windows 7 operating system and Debian version 6 to 8 and works without problems.
- Likewise I have worked in postgres since its version 8.1 to 9.6.6 and a positive change has been noticed and performance improvements, but I insist on the point at which the databases should be fine designed.

- Many people declare it as slow in insertions and updates compared to others Managers, however, that will depend on how well designed the database is.
- For some, not having support online or with an official help center can be a big disadvantage.
- It is advisable to have command knowledge to work on consoles and terminals to perform a good configuration

I really like PostgreSQL I have used it several times for large projects in my previous works and in the current one it is used as a database for the web page of the institution, the power of PL / pgSQL is excellent, it allows me to program commercial layers in the database without any problem this improves the response times of the final applications and allows investments in hardware in the database servers instead of in the application, the management of schemes is perfect. It is important to mention that it is free software that implies having a large database without licensing costs. A feature of PostgreSQL is the multiversion concurrency control that allows transactions consistent with time, which provides great performance advantages. PgAdmin is a graphical tool with which I can manage different databases easily and intuitively, execute SQL statements, as well as create backup copies or perform maintenance tasks. Another thing that I like about PostgreSQL is that it is available for many platforms, it is possible to install it from the repositories of the Linux version that I use. It should be noted that the PostgreSQL user community is one of the most active in the market

There are some things that I do not like about PostgreSQL, permissions allowance per user can be annoying, I have had to work many times on this and it is difficult, it is also relatively slow when I insert and update small databases. The official support does not have telephone or online support, although there are official forums available where users can express their doubts to which other users of the community respond. The syntax of some of your commands or statements may not be intuitive if you do not have a medium level of knowledge in the SQL language. I have had problems migrating from a PostgreSQL version to a higher one. Compatibility is sometimes relative.

PostgreSQL allows to control high concurrency, offering security by domain definitions, who can access the database server, the backup copies of the database can be made completely or only a table, according to the request, restorations and tasks maintenance, in addition to replicate in case of disasters.
It also allows to activate triggers to execute in tables or views in special cases or eventualities.
It has a friendly graphical interface for the administrator, through which they can be done from the creation of the database, to execute query querys and updates of the data, if necessary, you can have details with the status tool of the server referring to the queries that are executed in the DB (if there are locks, duration, etc.).
It allows the development of robust and efficient Databases

There is no online or telephone support. Only official forums are available where users expose their doubts that other users of the community respond to, ademas it consumes many resources

PostgreSQL is and always has been one of the most feature rich and solid databases available. Its price / performance / feature set is simply unmatched in the industry today.

There is a lot of old information on the internet that is no longer relevant to current versions and you must sift through this in some cases to find the modern and elegant solutions. It was touted as "slow" compared to MySQL in the early 2000's and much of that information is wrong due to lack of user experience with the product or no longer the case today.

It's a solid database tested over the years by half of the world. Whatever features you need it has it.

You'll often need to Google for the exact command you need to run, the docs are very dry and the syntax is unconventional.

You'll suffer greatly trying to write code to access the database.

If you want to upgrade, scale, or do anything significant with a large production database you're probably best off hiring a specialized consultant - it's risky and not easy.

PostgreSQL is by far the most user friendly and most advanced database system out of the top 5 popular choices. It's inherently relational making it easily compatible with ORMs, has many smaller quirks like jsonb storage, the WITH keyword, and a vast amount of data types. It's also one of the most dynamic DBMS as it releases major changes more than once a year, with an ecosystem that consistently adapts to these versions.

Extensions in pgsql could use a bit of streamlining (extensions like pg_cron or similar), which was a bit complicated to do in with CI. Another concern would be some stability issues with the latest pgAdmin database interface, but in all fairness that isn't directly an issue with pgsql.

PostgreSQL is so powerful, complete and stable. This should come with no surprise given the long history behind it. At the same time it's incredibly modern and supports new paradigms (like NoSQL, JSON data types) and it's also very simple to familiarize with.

It's unbelievable how PostgreSQL is not as well-known as one of his competitors (MySQL) notwithstanding the fact that is so much more powerful.

Highly recommended. It's the most powerful database engine I ever worked with. It has a lot of features that I used and worked very well: postgis for spatial searches, full-text search, partitions, etc.

At some point, we start having problems with very slow queries, and after some debugging we discover postgres decided to use the wrong index to perform the query plan. Probably because of bad stats but from time to time the problem happens again.

PostgreSQL has several advantages. It is lightweight and reliable. Search filters are very easy to understand. People who know the basics of the SQL language can do several queries, since PostgreSQL assembles selects. I can change it within the table itself, so I don't need to do the update command. On top of that, it's free and open source!

Sometimes the connection to the database drops (internal server error 500), and it is necessary to connect again. When the query has many records, the data return is slow. They are the only negative points of this tool.

1164/5000
-Easy installation and configuration in other environments.
- Pgadmin management interface of the databases, very intuitive and complete with the necessary to a few clicks, I recommend keeping the graphical tool for the stability it offers.
-It has a connection balancer, known as pgpool that allows to manage the cluster structure well.
-Principles of replication between active-active or active-passive servers
Variety of console-level command options for restore or backup tasks and maintenance tasks
-principal manager for developers for the scalability and stability it offers.
-Management of free access, which allows the use of it without any problem, without any cost
-Ideal manager for the management of relational databases
-Allows the management of different versions on the same server with multiple database intentions with different listening ports.

- Poor documentation
- Functional technicians commonly report a slowness at the BD level, but that depends on how the DB is structured and especially if good database practices are applied

One of the advantages of this manager is that it is simple to install and has a free license for various distributions and operating systems. It also allows you to configure the manager according to the team requirements. Other capabilities include the ability to run read-only queries while in recovery mode. pg-Admin, for example, is a graphical application that allows us to simply administer our database. It is a great resource distribution for complex queries, very adjustable, allowing it to be tailored to the needs of individuals who use it, Allows you to limit the number of incoming connections to avoid timeouts caused by developers.

Indexing is some times very slow. Also database syncing or importing and exporting database is some time a headache. Apart from that, I don't see any major shortcoming in it.

PostgreSQL is the most flexible database management system out there. It has a lot of plugins (data visualization, backup, performance, etc), which make it very expandable too, incredibly powerful configuration options, etc. It has almost any type of column that your system will ever need.

I really don't found any PostgreSQL problem until now, so I would recommend that you use it without any fear.

PostgreSQL is a full featured SQL server solution. it is free and open-source, PostgreSQL can be installed on many different platform like Linux, Windows, macOS and other. being open-source if has lots of contribute tools from the open-source community providing wide range solutions, PostgreSQL is also available in the cloud from all the major providers.

Management is less comfortable and some settings needs to be done in PostgreSQL configuration files, also database schema management tool is not so comfortable, but you can use 3rd party tools for that also

PostgreSQL or simply Postgres implements the SQL and advanced SQL standard very well. It can handle workloads ranging from small web applications to large data warehousing with many parallel users. Postgres provides a easy to use tool called pgAdmin to interact with and manipulate database. It provides support for complex data types like (multi-dimensional) Array, Json, user-defined types. PostgreSQL provides higher number of connections at cheap price. It support all types of indexing for faster retrieval of data. In my company we replaced our database server from MySQL to PostgreSQL because of PostgreSQL higher db connections connections in cheaper price as compared to MYSQL. It is also available free of cost till 10,000 rows on Heroku.

PostgreSQL query syntax for some complex queries like array, json, string functions and case operator are bit complicated to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as compared to MySQL and it is bit harder to search for help regarding some complex queries and database functions on google. Replication is not yet as well implemented as in MySQL.