PostgreSQL 14 Released: Optimized for Scaling Distributed Workloads and Developer Experience
Summary
PostgreSQL 14 introduces the ability to pipeline queries to a database, which can significantly improve performance over high latency connections or for workloads with many small write (INSERT/UPDATE/DELETE) operations. PostgreSQL 14 adds several new features to help with monitoring and observability, including the ability to track the progress of COPY commands, write-ahead-log (WAL) activity, and statistics on replication slots. Additionally, this release now makes the standard compliant SCRAM-SHA-256 password management and authentication system the default on new PostgreSQL instances. PostgreSQL is the worlds most advanced open source database, with a global community of thousands of users, contributors, companies and organizations. Built on over 30 years of engineering, starting at the University of California, Berkeley, PostgreSQL has continued with an unmatched pace of development.