Chapter 1. Key Advantages
Postgres Pro AXE offers the following key advantages:
Speed and efficiency: Processes analytical queries up to 20 times faster than Greenplum and 30 times faster than PostgreSQL, according to ClickBench and TCP-H/TCP-DS benchmark tests on complex queries.
Quick start: Uses the PostgreSQL syntax, which does not require deploying additional systems and training employees to use new tools.
Saving resources:
does not require integration with additional storages and ETL servers (Extract, Transform, Load)
consumes up to 10 times less RAM and CPU than Greenplum, according to benchmark tests
Simplified the development stack: Allows building full-scale data warehouses (DWH) using only Postgres Pro components.
Storing data in open formats accessible to external tools, such as BI systems, dashboards, and other applications:
the OLAP data of analytical tables is stored as Parquet files
the metadata of analytical tables is stored using SQL tables according to the DuckLake specification