Greenplum® and Yandex MPP Analytics for PostgreSQL overview
Greenplum® is an analytical, column-oriented DBMS designed for storing and processing large volumes of data.
Built on PostgreSQL, Greenplum® consists of multiple PostgreSQL database instances combined into a single cluster using MPP architecture. These instances communicate over a high-speed network, Interconnect. Each cluster node runs its own OS and uses dedicated memory and disk resources, enabling parallel data storage and processing across many nodes. This MPP architecture supports horizontal scaling, ensures high cluster availability, and delivers near-linear performance growth as you add resources.
Greenplum® use cases
- Analytical DB: for example, you can linearly accelerate large hash joins in Greenplum® by adding more CPUs or nodes.
- General-purpose database replacement: Greenplum® can serve as a drop-in alternative to Oracle DB, Microsoft SQL Server, or IBM DB2. It handles not only analytical workloads but also numerous short OLTP queries typical of PostgreSQL.
- High-performance alternative to PostgreSQL: based on PostgreSQL, Greenplum® supports many familiar PostgreSQL tools, such as JDBC and ODBC drivers, and conforms to the ANSI SQL:2008 standard.
Greenplum® in Yandex MPP Analytics for PostgreSQL
Greenplum® was originally developed as an open-source project; however, in 2024, access to its source code was restricted. Despite this, Yandex MPP Analytics for PostgreSQL continues to support Greenplum® version 6 using its open-source fork.
Yandex MPP Analytics for PostgreSQL enables you to deploy Greenplum® clusters in the Yandex Cloud infrastructure and automates most maintenance tasks, including:
- Provisioning resources, creating and reconfiguring databases, and applying software updates.
- Automatically restoring cluster resilience after failures.
- Creating backups using WAL-G, storing them in an S3 storage, and enabling point-in-time recovery (PITR) to any moment.
The solution also provides self-service tools for managing Greenplum® clusters:
- Roles for data access management.
- Command center and metrics for real-time cluster monitoring.
- Yezzey extension for setting up hybrid storage.
Yandex MPP Analytics for PostgreSQL clusters support seamless integration with other Yandex Cloud services, e.g., with Yandex Data Transfer for database migration or Yandex DataLens for data visualization.
See also
- Greenplum® official documentation
- Getting started with Yandex MPP Analytics for PostgreSQL
- Resource relationships in Yandex MPP Analytics for PostgreSQL
- Yandex MPP Analytics for PostgreSQL tutorials
Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.