Overall Satisfaction with PostgreSQL
Currently, we are using PostgreSQL to support some DevOps operations, mainly related to monitoring (as a Zabbix database server) and configuration management (it is the database used by our Puppet/PuppetDB environment). We use it as a regular deployment as well as a Database as a service (on AWS RDS).
- Handle large amounts of data.
- It is scalable (for reading purposes).
- It is compatible with so many languages as the language for triggers and stored procedures.
- PostgreSQL could have a solution to accept operations on all replicas.
- Could improve its "full vacuum schema" in order to be less painful for applications.
- Could have an in-memory table type instead of having to create a partition on an in-memory file system.
- Multiple languages for internal developing (triggers and stored procedures).
- Hot backup out of the box.
- Partitioning allowing use of different storage resources giving us savings.
- No license costs
- High availability
- Scalability
I've been using different databases for the past 20 years, solutions like MS SQL Server, MySQL, MariaDB, Interbase, Firebird, DB2, etc., and by using them I wasn't able to be neither close to the performance PostgreSQL deliver. Also, it is one of the most popular databases on the market so we always find good resources, either tools or DBA's to support it.
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