Path to this page:
Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2021-10-08 12:23:45
Message id: 20211008102345.4D1D1FA97@cvs.NetBSD.org
Log Message:
postgresql14: added version 14.0
PostgreSQL 14 contains many new features and enhancements, including:
Stored procedures can now return data via OUT parameters.
The SQL-standard SEARCH and CYCLE options for common table expressions have been \
implemented.
Subscripting can now be applied to any data type for which it is a useful \
notation, not only arrays. In this release, the jsonb and hstore types have \
gained subscripting operators.
Range types have been extended by adding multiranges, allowing representation of \
noncontiguous data ranges.
Numerous performance improvements have been made for parallel queries, \
heavily-concurrent workloads, partitioned tables, logical replication, and \
vacuuming.
B-tree index updates are managed more efficiently, reducing index bloat.
VACUUM automatically becomes more aggressive, and skips inessential cleanup, if \
the database starts to approach a transaction ID wraparound condition.
Extended statistics can now be collected on expressions, allowing better \
planning results for complex queries.
libpq now has the ability to pipeline multiple queries, which can boost \
throughput over high-latency connections.
Files: