The Group of PostgreSQL developers has announced the release of version 13, the latest version of the world’s most advanced open source database. It comes with improvements to its indexing and lookup system that benefit large databases, Includes space-saving, faster response time for queries, better query planning when enhanced statistic, and more.
PostgreSQL 13 contains many new features and enhancements, including:
1) It has improvements in space savings and performance gains from the de-duplication of B-tree index entries.
2) It has improved performance for queries that use aggregates or partitioned tables.
3) Made Better query planning when using extended statistics
4) Parallelized vacuuming of indexes (VACUUM — garbage-collect and optionally analyze a database)
5) Incremental sorting
6) Security Enhancements
If an intermediate query result is known to be sorted by one or more leading keys of a required sort ordering, the additional sorting can be done considering only the remaining keys, if the rows are sorted in batches that have equal leading keys.
In version 13 added the concept of a “trusted extension,” which allows database users to install extensions that superuser marks as “trusted.”
Release Date : 24 September, 2020
Release Notes : https://www.postgresql.org/docs/13/release-13.html
Download Link: https://www.postgresql.org/download/