Yandex Managed Service for PostgreSQL release notes
This section contains Managed Service for PostgreSQL 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.
Q4 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 Upgrading PostgreSQL version.
For more information about the updates in PostgreSQL version 16, see the PostgreSQL documentation
. - Added the
Q3 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 2023
- You can now export raw data on performance diagnostics using the ListRawSessionStates and ListRawStatements API methods.
- Added the
Session duration timeout
setting that controls the lifetime of the longest active session or transaction. The default value is 12 hours.
Q4 2022
-
Added support for PostgreSQL version 15.
Key changes in the new version:
- Added support for the
SQL MERGE
command that allows performing anINSERT
,UPDATE
, orDELETE
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
as default for databases. - Performance improvements, in particular, for in-memory and on-disk sorting.
To learn how to update a cluster, see Upgrading PostgreSQL version.
To learn more about new features and enhancements in PostgreSQL v15, see the PostgreSQL documentation
. - Added support for the
-
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 2022
- Added the
Inode usage
,Memory usage
, andFree space
charts to the cluster monitoring tab.Management console
- 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. For information about updating a cluster on your own, see Upgrading PostgreSQL version. - You can now create a database from a template with the CLI and Terraform.
CLI
- Added support for the
pg_cron
extension. - Installed an update to version 14.4
correcting the index corruption issues.
Q2 2022
- Updates
from versions 14.3, 13.7, 12.11, 11.16, and 10.21 were installed. - Clusters for 1C are available under versions 13 and 14.
Management console
- 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. - In the Terraform configuration files, the
database
and theuser
sections have been deprecated, and theyandex_mdb_postgresql_database
and theyandex_mdb_postgresql_user
resources have been added.Terraform
- Odyssey 1.3
is now available with support for prepared statements in transaction pooling mode. You can use thepool_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
andmax_replication_slots
settings.
Q1 2022
- Added the following extensions:
pgcompacttable
,clickhouse_fdw
, andorafce
. - Added the ability to create a new database from a template.
Management console