Yandex Managed Service for PostgreSQL release notes

September 2024September 2024

• Added support for PostgreSQL version 17. To learn how to update a cluster, see PostgreSQL version upgrade.
• Added support for the postgresql_anonymizer (anon) extension for data anonymization.

May 2024May 2024

Users with the mdb_admin role can now use the pg_stat_reset_single_table_counters() and pg_stat_reset_single_function_counters() functions.

March 2024March 2024

• Added the ability to configure incremental auto increase of cluster storage size. The user can set the disk storage usage threshold and the maximum disk size. Upon reaching the threshold, the disk size will automatically increase in fixed increments up to its maximum.

• Added the ability to upgrade PostgreSQL for 1C to version 13, 14, and 15.

• Installed the updates from 16.2, 15.6, 14.11, 13.14, and 12.18.

• Expanded the permissions for users with the mdb_admin role. Now they can:

  • Grant additional users permissions to use the pg_cron extension.
  • Reset statistics using the pg_stat_reset_shared() function.
  • Terminate the autovacuum sessions.

• Now you can audit Managed Service for PostgreSQL cluster connection events and pgaudit events in Yandex Audit Trails.

Q4 2023Q4 2023

Added support for PostgreSQL version 16.

Key changes in the new version:

• Added the pg_stat_io view for input/output monitoring.
• Added parallel execution of a full and a right hash connection.
• Improved the performance of the vacuum freeze operation.
• Added the logical replication setting from a replica.
• New version 16 clusters use ICU locales instead of libc.

To learn how to update a cluster, see PostgreSQL version upgrade.

For more information about the updates in PostgreSQL version 16, see the PostgreSQL documentation.

Q3 2023Q3 2023

PostgreSQL 11 is no longer supported. Starting August 14, you can no longer create new clusters of this version, and the existing clusters were automatically updated on September 12 as part of the maintenance window.

Q2 2023Q2 2023

• You can now export raw data on performance diagnostics using the PerformanceDiagnosticsService/ListRawSessionStates and PerformanceDiagnosticsService/ListRawStatements gRPC API calls.
• Added the Session duration timeout setting that controls the lifetime of the longest active session or transaction. The default value is 12 hours.

Q4 2022Q4 2022

• Added support for PostgreSQL version 15.

  Key changes in the new version:

  • Added support for the SQL MERGE command that enables performing the INSERT, UPDATE, or DELETE action depending on the conditions.
  • You can now specify column lists and row filter conditions. This allows selective publication of table contents within logical replication publications.
  • You can now specify ICU for a database by default.
  • Performance improvements, in particular, for in-memory and on-disk sorting.

  To learn how to update a cluster, see PostgreSQL version upgrade.

  For more information about the updates in PostgreSQL version 15, see the PostgreSQL documentation.

• Added support for the pgaudit and pg_prewarm extensions.

• You can now restore a cluster from backup in a different folder using any interface.

Q3 2022Q3 2022

• Added the Inode usage, Memory usage, and Free space charts to the cluster monitoring tab.
• PostgreSQL 10 is no longer supported. As of August 15, you can no longer create new clusters of this version, and an automatic cluster update is scheduled from September 1 as part of the maintenance window. To learn how to update a cluster on your own, see PostgreSQL version upgrade.
• You can now create a database from a template with the CLI and Terraform.
• Added support for the pg_cron extension.
• Installed an update to version 14.4 with index corruption issues fixed.

Q2 2022Q2 2022

• Updates from versions 14.3, 13.7, 12.11, 11.16, and 10.21 were installed.
• You can now create cluster versions 13 and 14 for 1C.
• Added the ability to upgrade versions from 13 to 14.
• Added the mdb_monitor role that includes the privileges of the pg_monitor system role. For more information, see Assigning roles.
• Removed the database and user sections in the Terraform configuration files and added the yandex_mdb_postgresql_database and yandex_mdb_postgresql_user resources instead.
• Odyssey 1.3 is now available with support for prepared statements in transaction pooling mode. You can use the pool_reserve_prepared_statement setting to activate a pool of prepared database statements where Odyssey will prepare session statements as needed.
• Added the max_logical_replication_workers and max_replication_slots settings.

Q1 2022Q1 2022

• Added the pgcompacttable, clickhouse_fdw, and orafce extensions.
• You can now create a new database from a template.