

VACUUM can now skip index vacuuming when the number of removable index entries is insignificant. In addition, we now allow an SSL certificate's distinguished name (DN) to be matched for client certificate authentication, and we add Server Name Indication (SNI) in SSL connection packets.
#POSTGRES 14 SHARDING FULL#
Passwords can now be much longer in both pgbouncer and PostgreSQL, allowing users to take full advantage of the security that SCRAM-SHA-256 provides. The default setting of password_encryption parameter is now SCRAM-SHA-256 to ensure that new users take full advantage of this important security feature, deprecating MD5 for new users. EDB staff in the Community made significant contributions to PostgreSQL 14 in these areas: We at EDB are once again delighted to be part of the latest release, reflecting our ongoing commitment to helping the Community constantly improve and build on the software. There are also improvements for managing larger databases and analytical systems, as well as improvements for time-series, graph query, and document data management. It handles partition writes faster, index growth better, and idle connections with less overhead. This release pushes PostgreSQL to new levels of performance for high-end workloads. The Cloud Native Computing Foundation positioned Postgres as the #1 database on its technology radar - a clear endorsement of Postgres in one of the most exciting new strategic technologies. Developers also selected Postgres as the most wanted database above all others.
#POSTGRES 14 SHARDING PROFESSIONAL#
And in the Stack Overflow 2021 Developer Survey, PostgreSQL leads the pack with 44% of professional developers choosing it as the most popular technology and 77% choosing it as most loved. The leading data technology review site, DB-Engines, named PostgreSQL Database Management System of the Year 2020, continuing to outpace MongoDB, Redis, and MySQL.

It’s been a year to celebrate the world’s best database. The news is out - PostgreSQL 14 is now available. By: Simon Riggs, Marc Linster, and Bruce Momjian
