Russian Postgres Professional has unveiled an update to Postgres Pro AXE, a robust system designed for the analysis of extensive data sets utilizing PostgreSQL. The latest iteration, version 2.0, introduces a significant enhancement: a mechanism that facilitates the handling of analytical data through standard SQL queries, eliminating the need for specialized stored procedures. This advancement allows users to interact with analytical data in the same manner as they would with conventional PostgreSQL tables.
The core improvement in AXE 2.0 revolves around the accessibility of analytical data. In previous versions, users were required to employ specific commands and pre-prepared procedures to access this data. The new Table Access Method mechanism now enables users to query analytical data seamlessly using standard SQL queries. This shift means that separate methods for analytics are no longer necessary, streamlining the user experience.
Within Postgres Pro AXE, analytical data is stored in the Parquet format, which is optimized for efficient data processing. The platform also incorporates a dedicated metadata catalog that contains essential information about analytical objects, allowing users to manage large volumes of data without the need to access the content of all files repeatedly. This architectural design is thoroughly documented in the Postgres Pro AXE documentation.
The system is tailored for analytical workloads that demand the processing of vast amounts of information. Postgres Professional emphasizes its support for Online Analytical Processing (OLAP) scenarios and hybrid workloads, where both transactional and analytical operations coexist within the same infrastructure.
The first public version of Postgres Pro AXE appeared in January 2026
The inaugural public release of Postgres Pro AXE made its debut in January 2026, showcasing features such as vectorized analytical queries, compatibility with columnar storage and Parquet files, capabilities for building data warehouses, and tools for analyzing historical data. Version 2.0 further enhances the integration of the analytical engine with PostgreSQL, marking a notable transition from specialized procedures to standard SQL.
This evolution ensures that Postgres Pro AXE remains a powerful system for analytical data processing while aligning more closely with the familiar PostgreSQL model. Users can now manage analytical tables, queries, and access rights within a unified environment, as outlined in the Postgres Professional documentation, which also covers the management of analytical tables, columns, schemas, Parquet files, and the metadata catalog.
Which Russian DBMS are used for analyzing large volumes of data
In the Russian market, several analytical database management systems (DBMS) offer functionalities similar to those of Postgres Pro AXE, albeit with different structural approaches. One notable solution is Arenadata DB, a massively parallel analytical DBMS designed for corporate data warehouses. It is optimized for executing complex queries on substantial volumes of structured and semi-structured data, with capabilities that extend to tens of petabytes.
Another contender is Arenadata QuickMarts, a clustered columnar DBMS built on ClickHouse, which excels in providing rapid analytics on large datasets. This system is particularly adept at handling data marts, operational reporting, event analysis, and log management.
