Although the speed of response may seem deficient in small databases, that speed is maintained by increasing the size of the database, which is not the case with other programs, which slow down brutally.
Unlimited installation: You can not sue a company for installing it on more computers than the license allows, as there is no cost associated with the software license. This allows for a more profitable business with large scale installations, we should not worry about being audited to see if we comply with the license, and there is flexibility and development without additional licensing costs.
Considerable savings in operating costs: PostgreSQL has been designed to have lower maintenance and adjustment than products of commercial suppliers, retaining all the features, stability and performance.
Stability and Reliability: No database crashes.
Extensible: The source code is available for free, so that whoever needs to extend or customize the program can do so without costs.
Multiplatform: Available on almost any Unix, with 34 platforms in the latest stable version, plus a native version of Windows in test state.
Designed for high-volume environments: Using a row storage strategy called MVCC, it gets better response in large volumes. In addition, MVCC allows read-only accesses to continue reading consistent data while updating records, allowing hot backups
Graphic design and database management tools.
It supports the SQL92 / SQL99 standard and standard type data, clauses, functions, and extended commands of PostgreSQL.
It can operate on different platforms, including Linux, Windows, Unix, Solaris and MacOS X.
Good security system through the management of users, groups of users and passwords.
Great storage capacity.
Good scalability as it is able to adjust to the number of CPUs and the amount of memory available optimally, supporting a greater number of concurrent requests to the database correctly.
Compared to MySQL it is slower in insertions and updates because it has intersection headers that does not have MySQL.
Online support: There are official forums, but there is no obligatory help.
Consume more resources than MySQL.
The syntax of some of your commands or statements is not at all intuitive.
Multiversion concurrency control; the MVCC; this method adds an image of the state of the database to each transaction. This allows transactions to be made consistently, offering great performance advantages. For example, it is not necessary to use read locks when performing a transaction, which provides greater scalability. thus solving scalability problems.