Overall Satisfaction with PostgreSQL
PostgreSQL is used in several Departmental Information Systems across the Bank, from open source systems which operates with the DBMS to in-house developed systems like the one we use for Operational and Technology Risk Assessment, and Asset Management.
We use other DBMSs like MySQL (MariaDB) and Microsoft SQL Server also, so we can compare them against each other.
- It is an excellent DBMS, which is scalable, performs well, allows replication, supports ACID and a big subset of the SQL standard (in several cases, it is a superset).
- Is much better at data types than the other DBMSs, with a more rich semantics, with geo-spatial types, complex numbers, etc.
- It supports several methods of indexation, including B-trees, Genetic Algorithms based indexes, and GIN indexes that accelerates full-text searches.
- Its flexibility to select from a variety of procedural languages to make stored procedures is astonishing.
- The performance of PostgreSQL has been enhanced through the years, but always is better to have as much performance as we can.
- The replication services could be done directly within the database, and more easily.
- The Object Orientation of the Database could be extended, and albeit it manages inheritance of tables, and accepts XML and JSON as primary types, it would be wonderful if one could attach methods more easily to tables (to make them more like classes), and instances (rows for example).
- Being open source free software, the ROI couldn't be better.
- There are a lot of young developers who know the technology and are interested in advancing their careers with the platforms and technologies in which they are invested. It is more easy to contract developers for the platform, then the projects are more quickly finished, then the ROI is made in shorter time.
- There is a lot of prejudice with PostgreSQL and open source in general, because, they say, there is no company behind it, but thank God, their minds are changing. A lot of companies and consultants will technically support your project and your infrastructure.
SQL Server is an excellent product from Microsoft, it is a derivative from Sybase which originally developed the SQL Server form Unix and Linux, and Microsoft purchased it to migrate the DBMS to Windows Server. But the cycle comes full circle, and now Microsoft recommends its use in Linux. The problem with SQL Server is its pricing scheme. Before 2012 it was sold by CPU, but after that, it was priced with licenses for 2 cores each, and its cost is in around USD 4K for the standard version and USD 15K for the Enterprise version. A sound recommendation for Microsoft, go back to your previous licensing scheme if you do not want your user base eroded by open source products like MariaDB or PostgreSQL.
SQL Server has better performance per core than PostgreSQL, when all other variables are equal (sometimes). But if you use all the available resources of your server for PostgreSQL and limit the cores you use for SQL Server (i.e.: to 1/4 of the cores), PostgreSQL runs circles around SQL Server.
In comparison to MariaDB, PostgreSQL adheres better to the standards and has a richer set of primary data types, among other advantages.
MariaDB is a derivative of MySQL, which gives you more freedom (given its license) that could give you Oracle, the actual owner and maintainer of MySQL.
Do you think PostgreSQL delivers good value for the price?
Yes
Are you happy with PostgreSQL's feature set?
Yes
Did PostgreSQL live up to sales and marketing promises?
Yes
Did implementation of PostgreSQL go as expected?
Yes
Would you buy PostgreSQL again?
Yes