Overview

PostgreSQL is an open source object-relational database management system (ORDBMS) that is typically utilized as both a production database and analytical database. While MySQL prioritizes scalability and performance, Postgres prioritizes SQL compliance and extensibility.

Organizations looking to maintain a high level of data integrity and customization will typically choose Postgres. This is due to PostgreSQL’s support of fully ACID transactions and custom procedures.

Unlike other open source transactional databases, Postgres also prioritizes ANSI SQL compliance, containing a comprehensive SQL library and extensible functionality that can be used to support advanced analytical workloads.

Postgres can be downloaded for free and deployed on commodity hardware, or it can be run in the cloud through a variety of vendors. While Postgres is feature-rich and tailored for OLAP workloads, performance in Postgres tends to hit a limit as data volumes scale beyond several terabytes.