> For the complete documentation index, see [llms.txt](https://functional.gitbook.io/database_comparison_report/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://functional.gitbook.io/database_comparison_report/postgresql/pros-of-postgresql.md).

# Pros of PostgreSQL

**Great scalability.** Vertical scalability is a hallmark of PostgreSQL, unlike MySQL DBMS. Considering that almost any custom software solution tends to grow, resulting in database extension, this particular option certainly supports business growth and development.

**Support for custom data types.** PostgreSQL natively supports a large number of data types by default, such as JSON, XML, H-Store, and others. PostgreSQL takes advantage of it, being one of the few relational databases with strong support for NoSQL features. Additionally, it allows users to define their own data types. As your software business model may need different types of databases throughout its existence for better performance or application comprehensiveness, this option brings improved flexibility to the table.

**Easily-integrated third-party tools.** PostgreSQL database management system has the strong support of additional tools, both free and commercial. The scope of these includes extensions to improve many aspects. For example, ClusterControl provides impressive assistance at managing, monitoring, and scaling SQL and NoSQL open source databases. To make data comparison and synchronization more effective, consider using DB Data Difftective. In case you’re going to scale up your data to heavy workloads, the pgBackRest backup and restore system will be a nice option to choose.

**Open-source and community-driven support.** Postgres is completely open-source and supported by its community, which strengthens it as a complete ecosystem. Additionally, developers can always expect free and prompt community assistance.