Yandex Managed Service for Greenplum® release notes

This section contains Managed Service for Greenplum® release notes.

Labels next to the revision description let you see in what interface it is supported: the management console, CLI, API, Terraform, or SQL.

July 2024July 2024

• Enabled managing PXF settings from the API and UI. You can now customize the import and export of data from other DBMSs, S3, and HDFS.

June 2024June 2024

Now you can create external S3, JDBC, HDFS, and Hive data sources for accessing external tables. Management console

February 2024February 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 2024January 2024

• A new version is available: Greenplum® 6.25. It features cold storage integration tools and a command center by default.
• Now you can configure PXF for accessing external tables yourself. Previously, users had to contact support for PXF configuration.

Q3 2023Q3 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. Management console
• Added audit logs in Yandex Audit Trails.

Q2 2023Q2 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 2022Q4 2022

• You can now expand a cluster via the CLI and API by adding new segment hosts with data redistribution across all segments. CLI
• 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. CLI
• 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: Management console
  • Cluster size cannot exceed <maximum_host_count> × <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 2022Q3 2022

• Added the ability to change the administrator password. CLI
• You can now configure the DBMS and the connection pooler in Terraform. 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. CLI
• 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 2022Q2 2022

• Added CLI support: yc managed-greenplum cluster and yc managed-greenplum hosts commands are available. CLI
• 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 of the pgcrypto extension.
• Optimized backup creation through special processing of append-only segments.
• Added the diskquota module allowing to limit the disk space taken up by database schemas.
• Implemented automatic switchover to a standby master host via gpactivatestandby.
• Added the max_statement_mem and log_statement settings that are available when creating or 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 vacuuming process (VACUUM):
  • The operation is carried out concurrently across several databases.
  • New tables are processed last.
  • Tables with active locks are excluded.

Q1 2022Q1 2022

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

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