From 11182806be4d22cd1b28f289815e5b368fce6d31 Mon Sep 17 00:00:00 2001 From: "Jonathan S. Katz" Date: Tue, 10 Sep 2019 21:06:18 -0400 Subject: [PATCH] Additional revisions per community feedback. --- releases/12/en/release.en.md | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/releases/12/en/release.en.md b/releases/12/en/release.en.md index d57de2b..35ef17c 100644 --- a/releases/12/en/release.en.md +++ b/releases/12/en/release.en.md @@ -16,7 +16,7 @@ B-tree Indexes, the standard type of indexing in PostgreSQL, have been optimized Queries on partitioned tables have also seen demonstrable improvements, particularly for tables with thousands of partitions that only need to retrieve data from a limited subset. PostgreSQL 12 also improves the performance of adding data to partitioned tables with "INSERT" and "COPY", and includes the ability to attach a new partition to a table without blocking queries. -There are additional enhancements to indexing in PostgreSQL 12 that affect overall performance, including lower overhead in write-ahead log generation for GiST, GIN, and SP-GiST indexes, the ability to create covering indexes (the "INCLUDE" clause) on GiST indexes, the ability to perform K-nearest neighbor queries with the distance operator ("<->") using SP-GiST indexes, and CREATE STATISTICS now supporting most-common value (MCV) statistics to help with columns that are nonuniformly distributed. +There are additional enhancements to indexing in PostgreSQL 12 that affect overall performance, including lower overhead in write-ahead log generation for the GiST, GIN, and SP-GiST index types, the ability to create covering indexes (the "INCLUDE" clause) on GiST indexes, the ability to perform K-nearest neighbor queries with the distance operator ("<->") using SP-GiST indexes, and CREATE STATISTICS now supporting most-common value (MCV) statistics to help generate better query plans when using columns that are nonuniformly distributed. Just-in-time (JIT) compilation using LLVM, introduced in PostgreSQL 11, is now enabled by default. JIT compilation can provide performance benefits to the execution of expressions in WHERE clauses, target lists, aggregates, and some internal operations, and is available if your PostgreSQL installation is compiled or packaged with LLVM. -- 2.39.5