Yandex 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.
May 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 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.
Management console
CLI
API
-
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.
- Grant additional users permissions to use the
-
Now you can audit Managed Service for PostgreSQL cluster connection events and
pgaudit
events in Yandex Audit Trails.
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 the PostgreSQL version.
For more information about the updates in PostgreSQL version 16, see the [PostgreSQL documentation](https://www.postgresql.org/docs/release/16.0/).
Q3 2023
PostgreSQL 11 is no longer
Q2 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 2022
-
Added support for PostgreSQL version 15.
Key changes in the new version:
- Added support for the
SQL MERGE
command that enables performing theINSERT
,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
for a database by default. - Performance improvements, in particular, for in-memory and on-disk sorting.
To learn how to update a cluster, see Upgrading the PostgreSQL version.
For more information about the updates in PostgreSQL version 15, 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. To learn how to update a cluster on your own, see Upgrading the PostgreSQL version. - You can now create a database from a template with the CLI and Terraform.
CLI
Terraform
- Added support for the
pg_cron
extension. - Installed an update to version 14.4
with index corruption issues fixed.
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. - Removed the
database
anduser
sections in the Terraform configuration files and added theyandex_mdb_postgresql_database
andyandex_mdb_postgresql_user
resources instead.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
pgcompacttable
,clickhouse_fdw
, andorafce
extensions. - Added the ability to create a new database from a template.
Management console