Contact UsGet started
© 2025 Direct Cursus Technology L.L.C.

Yandex MPP Analytics for PostgreSQL release notes

Written by
Updated at December 5, 2025

July 2025

Added a feature to transfer cluster logs to Yandex Cloud Logging.

May 2025

Added integration with Yandex WebSQL.

April 2025

You can now manage resource groups using the Yandex Cloud CLI.

October 2024

  • The default Log statement value is now DDL rather than ALL: Greenplum® only logs SQL commands used to change data structure definitions (such as CREATE, ALTER, DROP, etc.).
  • A new RAM limit has been introduced for each Greenplum® process. The limit is calculated using the following formula: <segment host RAM> ÷ (<Max connections> × <number of segments per host>).

September 2024

  • Yandex MPP Analytics for PostgreSQL is now available in the Kazakhstan region.

  • Added the new Monitoring and Network sections with plots for the respective metrics to the  PXF tab in the management console. For more information, see Monitoring cluster and host state.

  • Introduced the Yandex Query access option in the cluster settings. It enables you to run YQL queries from Yandex Query to a Yandex MPP Analytics for PostgreSQL database.

June 2024

You can now create external S3, JDBC, HDFS, and Hive data sources for accessing external tables.

February 2024

Added the ability to partially restore a cluster from a backup: you can now specify a list of databases or tables to restore. This greatly reduces recovery time and saves cluster resources when restoring small amounts of data.

January 2024

Q3 2023

  • Added support for incremental backups.
  • Added the option of committing a specific volume of services. All platform users can get a discount up to 22% starting August 1, 2023. The cost of services will not change while the discount is in effect.
  • Added PXF metrics to Yandex Monitoring.
  • Added logs for PXF and the Odyssey connection pooler.
  • Added audit logs in Yandex Audit Trails.

Q2 2023

  • You can now recover from a backup as of any point in time (Point-in-Time-Recovery, PITR). The feature is enabled by default for new clusters.
  • When recovering a cluster, you can now select the number of hosts and segments.
  • PXF has been updated to version 6.6.0.
  • Logs now support PXF-based events.

Q4 2022

  • You can now expand a cluster via the CLI and API by adding new segment hosts with data redistribution across all segments.
  • You can now view cluster backups, recover from backups, and modify public access to the cluster via the CLI. For more information, see YC CLI releases.
  • Added the mdb_toolkit.table_privileges() function that allows users with the mdb_admin role to view the history of granting and revoking privileges in the cluster. For more information, see this PostgreSQL guide.
  • Added the mdb_toolkit.gp_workfile_usage_per_query() function that allows users with the mdb_admin role to view information about active queries from all users. For more information, see this Greenplum® guide.
  • Improved the algorithm for creating clusters via the wizard:
    • The cluster size cannot exceed <maximum_number_of_hosts> × <maximum_disk_size_per_host>.
    • You can select groups of dedicated hosts to deploy the cluster.
    • If the amount of data you specified is large, the wizard will prompt you to create a cluster on dedicated hosts.

Q3 2022

  • You can now change the administrator password.
  • You can now configure the DBMS and the connection pooler in Terraform.
  • Added support for the postgis extension.
  • Added the ability to edit clusters and cluster settings via the CLI as well as grant access from Yandex Data Transfer. For more information, see YC CLI releases.
  • Updated the master failover mechanism: a former master is returned to a cluster as a replica and is available for another failover right after the first one completes.
  • Added the gp_cancel_backend function to forcibly stop user queries.
  • Added the gp_terminate_backend function to forcibly terminate user DB connections.
  • Added the ability to expand a cluster with new segment hosts via the API and re-distribute data across all segments.

Q2 2022

  • Added CLI support, with yc managed-greenplum cluster and yc managed-greenplum hosts commands now available.
  • You can now migrate databases from/to Yandex MPP Analytics for PostgreSQL using Yandex Data Transfer. For a list of available targets and sources, see this guide. This feature is at the Preview stage.
  • Added support for the pgcrypto extension.
  • Optimized backup creation through special processing of append-only segments.
  • Added the diskquota module that enables you to limit the amount of disk space used by schemas in a database.
  • Implemented automatic switchover to a standby master host using the gpactivatestandby utility.
  • Added the max_statement_mem and log_statement settings that are available when creating and changing a cluster.
  • Added the ability to create a cluster with an odd number of segments.
  • Limited the minimum storage size on network SSD disks for a master host to 100 GB.
  • Optimized the cleaning process (VACUUM):
    • The operation is carried out concurrently across several databases.
    • New tables are processed last.
    • Tables with active locks are excluded.

Q1 2022

  • Yandex MPP Analytics for PostgreSQL is now publicly available. It is now subject to a Service Level Agreement (SLA) and pricing rules.
  • A new version is out with known bugs fixed: Greenplum® 6.19.
  • You can now hide the contents of external tables.
  • You can now change the storage size, including for local SSDs.
  • Added the io-optimized configurations with an increased GB RAM to vCPU ratio (8:1).

Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.

Previous
Public materials
Next
General questions