Contents hide 1) PostgreSQL v13 2) In shots 2.1) Incremental sorting 2.2) Security Enhancements 3) Links 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 v13 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 In shots Incremental sorting 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. Security Enhancements In version 13 added the concept of a “trusted extension,” which allows database users to install extensions that superuser marks as “trusted.” Links Release Date : 24 September, 2020 Release Notes : https://www.postgresql.org/docs/13/release-13.html Download Link: https://www.postgresql.org/download/ get Latest News: https://www.geekstrick.com/news Share this:TwitterFacebookRedditLinkedInWhatsAppPrintTumblr Related