Arenadata Documentation
Our passion is to build efficient flexible solutions that scale up to dozens of petabytes
Products
Explore our range of solutions in the world of Big Data

Arenadata Postgres

Arenadata Postgres (ADPG) is a DBMS for efficient work with loads of different profiles (primarily OLTP - Online Transaction Processing). ADPG allows you to work with various amounts of data and supports a wide range of data types (including JSON and custom types) with the ability to create data processing mechanisms.
ADPG key features:
  • complex queries that process large amounts of data with complex analytical functions (including user behavior analytics);
  • variety of reporting types (operational, managerial, mandatory regulatory);
  • deep AD-HOC analysis;
  • efficient joining of large tables;
  • integration with marketing campaign systems and loyalty systems;
  • full-text search;
  • predictive analytics (demand, balances).
Use cases
Web applications

ADPG is an excellent choice for building web applications due to its support for structured and unstructured data, rich data types, and scalability. Many web applications, including social media platforms, e-commerce websites, and content management systems, use PostgreSQL as their primary database.

Analytics and business intelligence

With its advanced analytics capabilities, ADPG is an excellent choice for businesses that require robust data analysis and business intelligence tools. Its support for advanced SQL features, such as window functions and common table expressions, make it easy to perform complex data analysis tasks.

Financial services

ADPG supports for ACID transactions, multi-version concurrency control (MVCC), and data integrity. These features make ADPG an ideal choice for financial applications such as trading platforms, payment processing systems, and banking applications.

Geographic information systems

Support for spatial data types and integration with GIS tools make ADPG an excellent solution for storing and analyzing geographic data in mapping, geocoding, and routing applications.

Internet of things

ADPG can process time-series and supports JSON data types. This allows ADPG to be successfully used in IoT applications that require storing and analyzing large amounts of sensor data.

Healthcare

PostgreSQL is widely used in healthcare applications, where data security and compliance are of utmost importance. You can utilize ADPG to store patient records, medical researches, and clinical trial data.

Enterprise
Community
Offline installation
Highly available cluster
Load balancing
Built-in PostGIS
Built-in contrib
Cluster monitoring
TimescaleDB support
Technical support 24/7
Corporate training courses
Tailored solutions
Deploy & upgrade automation
Available integrations
ADQM
ADQM
Special database's and table's engines of Arenadata QuickMarts (ADQM) allow you to replicate data form ADPG databases and single tables and use INSERT statements.
ADB
ADB
ADPG can be used as data source for Arenadata Database (ADB) as well as data storage for ADB Control and Arenadata DB Backup Manager products.
ADH
ADH
ADPG can be used as the metastore for Arenadata Hadoop (ADH) components.
ClickHouse
ClickHouse
Special database's and table's engines of ClickHouse allow you to replicate data from ADPG databases and single tables and use INSERT statements.
Greenplum
Greenplum
The postgres_fdw extensions, which have the same names in Greenplum and ADPG, can be used to access Greenplum data from ADPG and vice versa.
Apache Hive
Apache Hive
ADPG can be used as the metastore for Apache Hive.
Apache Ranger
Apache Ranger
ADPG can be used as the metastore for Apache Ranger.
Oracle
Oracle
ADPG can use the oracle_fdw extension to collect data from Oracle Database.
MS SQL
MS SQL
ADPG can use the tds_fdw extension to collect data from MS SQL Server.
MySQL
MySQL
ADPG can use the mysql_fdw extension to collect data from MySQL Server.
Apache Spark
Apache Spark
Apache Spark is compatible with ADPG via JDBC and allows you to manage and analyze big data.
Apache Superset
Apache Superset
Apache Superset Business Intelligence framework is compatible with ADPG and allows you to analyze and visualize big data.
Operating systems
Alt Linux 8 SP
Supported
CentOS 7
Supported
RedHat 7
Supported
AstraLinux
Currently in development
Red OS 7.3.
Currently in development
Offline installation
Highly available cluster
Load balancing
Built-in PostGIS
Built-in contrib
Cluster monitoring
TimescaleDB support
Technical support 24/7
Corporate training courses
Tailored solutions
Deploy & upgrade automation
Available integrations
ADQM
ADQM
Special database's and table's engines of Arenadata QuickMarts (ADQM) allow you to replicate data form ADPG databases and single tables and use INSERT statements.
ADB
ADB
ADPG can be used as data source for Arenadata Database (ADB) as well as data storage for ADB Control and Arenadata DB Backup Manager products.
ADH
ADH
ADPG can be used as the metastore for Arenadata Hadoop (ADH) components.
ClickHouse
ClickHouse
Special database's and table's engines of ClickHouse allow you to replicate data from ADPG databases and single tables and use INSERT statements.
Greenplum
Greenplum
The postgres_fdw extensions, which have the same names in Greenplum and ADPG, can be used to access Greenplum data from ADPG and vice versa.
Apache Hive
Apache Hive
ADPG can be used as the metastore for Apache Hive.
Apache Ranger
Apache Ranger
ADPG can be used as the metastore for Apache Ranger.
Oracle
Oracle
ADPG can use the oracle_fdw extension to collect data from Oracle Database.
MS SQL
MS SQL
ADPG can use the tds_fdw extension to collect data from MS SQL Server.
MySQL
MySQL
ADPG can use the mysql_fdw extension to collect data from MySQL Server.
Apache Spark
Apache Spark
Apache Spark is compatible with ADPG via JDBC and allows you to manage and analyze big data.
Apache Superset
Apache Superset
Apache Superset Business Intelligence framework is compatible with ADPG and allows you to analyze and visualize big data.
Operating systems
Alt Linux 8 SP
Available only for Enterprise
CentOS 7
Supported
RedHat 7
Supported
AstraLinux
Currently in development
Red OS 7.3.
Currently in development
Features
Reliability
Highly available cluster with automatic failover
Observability
Advanced monitoring features
Performance
Read-only load balancing on the cluster nodes
Scalability
Replication allows you to scale cluster to any number of databases
Convenience
Cluster deployment, upgrading and management with ADCM
Roadmap
2023
ADPG 14.3.4
  • Cluster monitoring feature based on pgwatch2 is added
  • TimescaleDB extension for metrics storage is supported
  • Grafana dashboards with monitoring metrics are provided
ADPG 14.3.3
  • Load balancing feature is added
  • The contrib and PostGIS extensions are included in ADPG and do not require installation
ADPG 14.3.2
  • High availability (HA) feature based on Patroni is implemented
  • The Etcd service required for HA is added
  • Offline installation is supported
ADPG 14.3.1
  • ADPG migrates to PostgreSQL 14.3
  • Alt Linux 8.4 SP is supported
  • Base monitoring system is implemented
ADPG 14.2.1
  • The ADCM-integrated ADPG bundle is created based on PostgreSQL 14.2
  • The contrib and PostGIS 3.1.5 extensions are supported