Collection of extended statistics on expressions to allow better planning results for complex queries.Updates on the B-tree index are managed more efficiently, reducing index bloat.Extension of Range types by adding multiranges, allowing representation of noncontiguous data ranges.Implementation of SQL-standard SEARCH and CYCLE options for common table expressions.In PostgreSQL 14, stored procedures can return data via OUT parameters.Below is a highlight on PostgreSQL 14 release features and improvements as shared in the release notes. PostgreSQL is a database fit for use in designing and running of distributed workloads that needs logical replication, query parallelism, high-write workloads, connection concurrency, and many advanced features. In PostgreSQL 14 release, there are tons of improvements and new features. At the time of updating this article, the latest release of PostgreSQL database is version 14. PostgreSQL is a fully open source, production grade relational database management system build with love. Throughout its journey, it has earned a strong reputation for its reliability, robustness, and performance.
The PostgreSQL database management system has been in active development for over 30 years now.
0 kommentar(er)
