PostgreSQL - open-source, flexible and futuristic
June 05, 2019

PostgreSQL - open-source, flexible and futuristic

Jacob Biguvu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

Capital One has many LOBs (line of businesses). I have supported IAM and Commercial
LOB. They are using PostgreSQL as an OLTP database solution. Company is using Oracle, SQL Server as OLTP solution for the most of their requirements. Since everyone moving to Cloud and want to use the open-source solutions, the company encourages the IT teams to use PostgreSQL.
  • Open-source. No license issues like Oracle and SQL server.
  • Full SQL Compliance.
  • GIS extension for search engines or queries.
  • Extensions/plugins to be used for on-premises and cloud technologies.
  • Easy installation/configuration.
  • Performance optimization is needed for the database as well as SQL.
  • Saves budget.
  • Meet the objectives if we properly utilize the features provided by Cloud/Server provider.
MySQL is also an open-source relational database management system. Both support ACID requirements, Full-text-search. Both are available for Cloud solutions. However, I would recommend PostgreSQL.
It is open-source, easy to install/configure, provided more features and growing database solution. It has a good future. supporting redshift as it is the same family. Easy to manage both at one time.
PostgreSQL is best for OLTP applications and searches engines/queries. Want to save the budget? PostgreSQL is best. Want database support on On-premises and Cloud? PostgreSQL is best.

For the non-critical applications, I would recommend using PostgreSQL. For critical applications, I would recommend going through the database design, modeling, and architectural decision-making process. Proper design decisions mitigate many performance issues.