Yandex Managed Service for Greenplum® release notes
Written by
Updated at September 9, 2024
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 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 2024
Now you can create external S3, JDBC, HDFS, and Hive data sources for accessing external tables. Management console
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
- 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 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 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.
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 themdb_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 themdb_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.
- Cluster size cannot exceed
Q3 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 2022
- Added CLI support:
yc managed-greenplum cluster
andyc 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
andlog_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 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.