Yandex Managed Service for Greenplum® release notes
Written by
Updated at April 3, 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.
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
API
- 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
Terraform
- 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 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
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.