percona/percona-postgresql-operator v2.8.1

on GitHub

Release Highlights

This release provides the following features and improvements:

PostgreSQL 18 support

You can now deploy PostgreSQL 18 on Kubernetes with the Operator. This latest major version of PostgreSQL delivers major improvements in performance, usability, and security, empowering you to make large-scale, mission-critical deployments more reliable and efficient.

Key improvements of PostgreSQL 18 are:

• Asynchronous I/O (AIO) boosts throughput and reduces latency for sequential scans, vacuums, and other heavy operations. This means faster queries and smoother performance under load.
• Queries can now use multi-column B-tree indexes more effectively. Users benefit from faster lookups without needing redundant indexes.
• Upgrades made via pg_upgrade no longer discard optimizer statistics. This reduces downtime and ensures consistent query performance after migrations.
• You can now enforce PRIMARY KEY, UNIQUE, and FOREIGN KEY constraints over ranges of time. This is especially valuable for applications managing time-series or historical data.
• Generated columns are now computed at read time by default. This reduces storage overhead and makes schema design more flexible.

Read more about PostgreSQL 18 in:

• Percona Blog: Planning Ahead for PostgreSQL 18: What Matters for Your Organization
• PostgreSQL 18.1 release notes

Find PostgreSQL 18 images in the list of Percona-certified images.

Supported software

The Operator 2.8.1 is developed, tested and based on:

• PostgreSQL 18.1-1, 17.7-1, 16.11-1, 15.15-1, 14.20-1, 13.23-1 as the database. Other versions may also work but have not been tested.

• pgBouncer 1.25.0-1 for connection pooling

• Patroni version 4.1.0 for high-availability

• PMM Client 3.5.0

• PostGIS:

  • version 3.5.4 for PostgreSQL 18,
  • version 3.3.8 for PostgreSQL 17, 16, 15, 14, and 13

Supported platforms

Percona Operators are designed for compatibility with all CNCF-certified Kubernetes distributions.

Our release process includes targeted testing and validation on major cloud provider platforms and OpenShift, as detailed below for Operator version {{release}}:

• Google Kubernetes Engine (GKE) 1.31 - 1.33
• Amazon Elastic Kubernetes Service (EKS) 1.31 - 1.34
• Azure Kubernetes Service (AKS) 1.32 - 1.34
• OpenShift 4.16 - 4.20
• Minikube 1.37.0 with Kubernetes v1.34.0

This list only includes the platforms that the Percona Operators are specifically tested on as part of the release process. Other Kubernetes flavors and versions depend on the backward compatibility offered by Kubernetes itself.