Personal blog of Yzmir Ramirez

When using a tool for a while, one often becomes patriotic towards it. With your investment, such as your work, you’re building up experience and starting to care more about the tool you use. How good it is, how it’s perceived by others. It’s an interesting process. Being strongly involved with PostgreSQL, it was interesting […]

According to the official PostgreSQL versioning policy page, the final PostgreSQL 11 release is expected by November 9, 2023. Since no new releases are planned by that date, PostgreSQL 11 has effectively reached its End of Life.

We encourage our users and customers to adopt upgrade strategies in line with the PostgreSQL Community timelines. According to Percona’s Release Lifecycle policies, there will be no public builds available from Percona for bugs or security fixes for PostgreSQL 11. Since the upstream development of PostgreSQL 11 has ended, we are removing PostgreSQL 11 from our officially supported software list.  However, we will continue to offer support on a best-effort basis to all existing customers who are still using PostgreSQL 11.

Before updating, consider reviewing our post on updating legacy PostgreSQL. We recommend upgrading at least to PostgreSQL 12, but it is also important to note that PostgreSQL 12 will have its final release on November 14, 2024. Given the enhancements in each version, it’s highly recommended to use the newer PostgreSQL versions. Please consider that the newest release, PostgreSQL 16, is already available in Percona Distribution for PostgreSQL. This version brings some very welcome improvements to replication, monitoring, and more.

When planning your database upgrade, remember that Percona offers a variety of top-market professional services to make your PostgreSQL upgrade a breeze.

Percona Distribution for PostgreSQL is an enhanced version of vanilla PostgreSQL that includes security, high availability, and performance extensions, all certified and tested to work together. It’s everything you need to run PostgreSQL in the most demanding business environments, right out of the box. 

Learn more about Percona Distribution for PostgreSQL

PostgreSQL Community released PostgreSQL 16 on September 14, 2023.  In years past, we’ve released our Distribution for PostgreSQL a few months later.  We wanted to improve in this regard and establish a new release baseline. Improving quality while maintaining the same resilience towards QA was something we aimed for. It looks like we succeeded, and I’m happy to announce that Percona Distribution for PostgreSQL 16 is now available!

The rocky road to a faster release

It took efforts across the Build and QA teams at Percona. We’ve improved both the packaging build pipelines and tremendously reworked and improved the automation of our QA pipelines. The effort has definitely paid off, as we can release shortly after upstream.

Why should you care about version 16?

PostgreSQL 16 comes packed with features. The community has been working hard on these, and the list of delivered improvements is really impressive. To highlight some:

• Logical replication from standby servers is now supported natively by PostgreSQL.
• Parallelization for transactions for logical replication subscribers.
• Parallelization of FULL and internal right OUTER hash joins is now allowed.
• pg_stat.io view providing I/O statistics for your monitoring needs,
• New SQL/JSON constructors and identity functions.
• Improved vacuum freezing performance.
• Added support for regular expression matching of user and database names in pg_hba.conf, and user names in pg_ident.conf.

To learn more about these, check out the upstream release notes and the Percona distribution release notes for more details!

What’s next in store?

We’re working hard on closing the gaps for data at rest encryption (DARE), as reported by both our community of users and our customers. While there are proprietary tools out there, as well as limited capabilities thanks to pg_crypto, it is still far from the expectations of enterprise customers who need to comply with regulations and internal policies.

We plan to make Percona images for PostgreSQL available on Docker Hub shortly. The plan is to start with version 16.

We’re hoping to share some good news in this regard and provide an MVP for all of you to try and test by the end of this year. As we are committed to open source, we hope to involve the community in discussing the best approaches for transparent data encryption (TDE) in PostgreSQL.

Learn more about Percona for PostgreSQL