PostgreSQL 14 Beta Released With More Performance Improvements
Like with recent major feature releases of PostgreSQL, version 14 is bringing more significant work in this department. Today's beta one announcement notes, "This release has significant improvements in transaction throughput for PostgreSQL systems that have large numbers of connections to the database, regardless if they are in an active or idle state. PostgreSQL 14 also contains additional gains in reducing B-tree indexing overhead, including reducing the bloat on tables with frequently updated indexes. GiST indexes can now presort data during their build process, allowing both for faster index creation and smaller indexes...There are many improvements to query parallelism in PostgreSQL 14. In addition to overall performance improvements for parallel sequential scans, the RETURN QUERY directive in PL/pgSQL can now execute queries with parallelism. REFRESH MATERIALIZED VIEW can now use query parallelism as well...PostgreSQL 14 also introduces the ability to leverage query parallelism when querying remote databases using foreign data wrappers."
In addition to those performance enhancements and other changes in the name of better performance, PostgreSQL 14 is introducing a new multi-range type, VACUUM handling improvements, logical replication improvements, some minor security enhancements, and other improvements.
More details on all of the feature work building up for PostgreSQL 14.0 can be found via today's beta 1 announcement.
15 Comments
