Chapter 1. Overview
Postgres Pro AXE is a Postgres Pro solution that provides the following functionality:
OLTP (online transaction processing) and OLAP (online analytical processing) scenarios using Postgres Pro DBMS.
Vectorized database queries and using the columnar data storage model when working with Postgres Pro tables, as well as with external storages.
OLAP data warehouses based on Star and DataVault methodologies.
Storing the OLAP data of analytical tables as Parquet files.
Fast historical data search and analysis.
The key components of the solution are:
Postgres Pro DBMS that processes OLTP and OLAP data.
pgpro_axe: A Postgres Pro columnar-vectorized analytics engine that, among the rest, supports storing OLAP data as Parquet files in network, local, and S3 storages. This extension consists of the following components:
Proprietary Postgres Pro AXE components.
Postgres Pro components.
DuckDB and its functionality.
pgpro_metastore: The extension designed for managing analytical tables and access privileges to these tables.
Postgres Pro AXE offers the following advantages:
Quick start:
uses the PostgreSQL syntax
works with Postgres Pro Enterprise and does not require deploying additional systems and training employees to use new tools
Efficiency: Processes analytical queries as fast as the best specialized DBMS.
Saving resources: Reduces hardware requirements on OLTP servers by removing OLAP workload from them.
Simplifying the development stack, deployment, and usage of OLAP functionality:
allows building full-scale data warehouses (DWH) using only Postgres Pro components
provides OLAP functionality to Postgres Pro Enterprise instances without using any additional tools