Question
Kynerja Abadi Solusindo
ID
Last activity: 20 Sep 2022 16:57 EDT
What are the advantages and disadvantages of using PostgreSQL for PEGA
We have a plan to use PostgreSQL as our database, because we have no experience using PostgreSQL before, we want to know what are the advantages and disadvantages of using PostgreSQL for PEGA compared to the other databases (such as performance, etc.). So, if you have experience using it before, please share it with us.
Thank you and I really appreciate it.
Updated: 20 Sep 2022 16:57 EDT
Pegasystems Inc.
US
Some advantages to selecting PostgreSQL from my perspective: It is open source, with a very large user base worldwide. If/when you run into issues and search for more info about an error, there is usually a lot of info available because of the large user base. Has a great open source management tool in pgAdmin 4 v6, and managing backups/restores is easy to do, with great documentation available. For important workloads that require HA, they have options for that, and they also a corporate support organization available to subscribe to for those orgs that need it.
I can't come up with disadvantages, we try to use PostgreSQL as default option whenever possible for the internal teams that I work for. There are advantages to having the support from the other not open source DB options. If you are planning to have really large deployments, require immediate support etc. then you definitely should be able to find a better comparison of the major DB players that has disadvantages for pg.