Skip to content
Percona Documentation

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

Percona Distribution for PostgreSQL 17.0.1 has been released

Percona Distribution for PostgreSQL 17.0.1 has been released on October 3, 2024.

Try it out using the Quickstart guide. Check the upgrade instructions

This is the next major version of PostgreSQL, and instead of the native PostgreSQL server it is now based on Percona Server for PostgreSQL which is a binary drop-in replacement for PostgreSQL. Read more about Percona Server for PostgreSQL

In addition, this release includes the following improvements:

  • Incremental base backup with the new pg_combinebackup tool. This feature is especially beneficial for organizations with large data sets where a full backup is a time-consuming and resource-intensive operation.
  • Improved performance via the new internal data structure of the VACUUM process, new stream I/O interface can enhance performance during sequential scans and when running the ANALYZE command and the support for parallel index builds for BRIN indexes, which can significantly speed up index creation
  • Developers can now transform JSON objects into a standard database table and convert JSON values to different data types directly within SQL statements. This adds flexibility when working with multiple data formats.
  • Gain more control for managing PostgreSQL databases in high availability environments with the ability to continue logical replication from a new primary node after the failover.
  • Convert a physical replica into a logical one using the new pg_createsubscriber command-line tool
  • Users with the new pg_maintain role can perform maintenance operations such as ANALYZE, VACUUM, REINDEX, CLUSTER, REFRESH MATERIALIZED VIEW, and LOCK TABLE on all relations.
  • New options for the EXPLAIN command provide more insights about query plans and execution

Learn more in Percona Distribution for PostgreSQL 17.0.1 release notes.