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

Yandex Managed Service for Greenplum® release notes

Written by
Updated at December 4, 2024

October 2024

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

September 2024

  • Managed Service for Greenplum® 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.

  • Added the Yandex Query access option to cluster settings. It enables you to run YQL queries from Yandex Query to a Managed Service for Greenplum® database.

June 2024

Now you can 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: now you can specify a list of databases or tables to restore. This greatly reduces the recovery time and saves cluster resources if 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 users of the platform can get a discount up to 22% starting from August 1, 2023. The cost of services will not change during the whole period of the offer.
  • Added PXF metrics to Yandex Monitoring.
  • Added logs for PXF and the Odyssey connection manager.
  • 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 is 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 the PostgreSQL documentation.
  • 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 the Greenplum® documentation.
  • Improved the algorithm for creating clusters via the wizard:
    • 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 specify 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 CLI as well as to 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 becomes 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: yc managed-greenplum cluster and yc managed-greenplum hosts commands are available.
  • You can now migrate databases from/to Managed Service for Greenplum® using Yandex Data Transfer. See the documentation for available targets and sources. 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 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 Managed Service for Greenplum® 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 VMware, Inc. in the United States and/or other countries.

Previous
Public materials
Next
General questions