Chapter 2. Main Compontents
The main components of Postgres Pro AXE are:
Postgres Pro DBMS.
pgpro_axe: The columnar-vectorized analytics engine that provides fast queries to the columnar data sources, i.e., Parquet files and temporary tables. It is almost completely compatible with the PostgreSQL syntax and can work with the OLAP data from local, network, and S3 storages. pgpro_axe also allows joining the data from Postgres Pro heap tables and columnar sources within one analytical query.
This extension consists of the following components:
proprietary Postgres Pro AXE components
Postgres Pro components
DuckDB and its functionality
pgpro_metastore: The catalog of analytical tables that allows granularly configuring access privileges to Parquet files and managing the metadata of these files, as well as performing transactional updates to analytical tables.
The solution can be scaled vertically and horizontally at any time.