Shulou(Shulou.com)05/31 Report--

This article focuses on "what are the improvements in PostgreSQL 12". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn what are the improvements in PostgreSQL 12.

"Automatic" performance improvements

"Automatic" performance improvements is the performance improvement that "naturally" brings when a large version is upgraded.

Automatic inlining of common table expressions (CTEs)

This improvement has been introduced previously and can lead to significant performance improvements in extreme cases.

Allow parallelized queries when in SERIALIZABLE isolation mode

Parallel queries are allowed in SERIALIZABLE isolation mode.

Enable Just-in-Time (JIT) compilation by default

PG 11 or previous versions, which do not enable JIT by default, are enabled by default starting from 12.

Developer changes

Development-related improvements in PG 12

Support for the SQL/JSON path language

This feature has also been introduced earlier, and the new SQL/JSON in PG 12 greatly improves the "usability".

Allow foreign keys to reference partitioned tables

Foreign keys can be allowed to refer to partition tables, which were not supported in previous versions.

Add partition introspection functions

Simplifying partition management, PG 12 provides several data dictionaries for querying partition information, including pg_partition_root (), pg_partition_ancestors () and pg_partition_tree ()

Add connection parameter tcp_user_timeout to control libpq's TCP timeout

In the case of poor network environment, increase the tcp_user_timeout parameter to avoid hang caused by network connection and other reasons.

Show the manual page URL in psql's "\ h [elp]" output for a SQL command

If you are interested in improving the information, take a look at PG 11 and PG 12.

Allow VACUUM to skip index cleanup

Improve VACUUM performance by disabling index cleanup.

Add EXPLAIN option SETTINGS to output non-default optimizer settings

For the parameters that affect the execution plan, if modified, the modified configuration parameters are displayed by specifying the parameter.

Allow logging of statements from only a percentage of transactions

The log_transaction_sample_rate parameter has been added to implement this function. This feature applies to these scenarios where you want to get the actual SQL from the log information without unduly affecting performance.

DBA changes

Improvements in DBA

Cause recovery to advance to the latest timeline by default

The default is changed from current to latest, which is widely expected.

Parallel automatic index rebuilding

Index rebuilding is performed in parallel using REINDEX CONCURRENTLY.

The "pg_checksums" utility can now enable/disable page checksums for an offline cluster

The "pg_checksums" tool can disable / enable page checksum.

Allow values produced by queries to be assigned to pgbench variables

The returned result values in the query can be used to assign values to variables in pgbench.

At this point, I believe you have a deeper understanding of "what are the improvements in PostgreSQL 12?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.