PostgreSQL 10 First Beta release

MySQL from 5.7 to 8.0,PG from 9.6 to 10, dried up.

The first beta version of PostgreSQL 10 was released, which contains a preview of all the features that PostgreSQL 10 will eventually provide. Of course, some details will be changed before the final release.

PostgreSQL 10 Key Features:

The new version allows users to scale out and scale up their PostgreSQL infrastructure at the same time:

• Logical replication: Built-in options for replicating a specified table or using replication for upgrade

• Native Table Partition: As the scope and list partition of a Native database object

• Additional query parallelism: Includes index scan, bitmap scan, and merge connection

• Quorum Commit synchronous replication: Ensure that multiple nodes are not lost

There are also three improvements to the PostgreSQL connection:

• Scram Authentication for more secure password-based access

• Multi-Host "failover", connecting to the first in the host list

• Target_session_attrs parameter, the client can request a read/write host

Additional Features

Many improvements and new features have been added in PostgreSQL 10. Some of these features and improvements may be as or more important to some users as the above features.

• Crash-safe and replicable Hash Indexes

• Multi-column Correlation Statistics

• New "Monitoring" role in licensing

• Lock the wait time in pg_stat_activity

• XMLTABLE query expressions

• Restrictive policies for row-level security

• Full-Text search support for JSON and JSONB

• Compression support for Pg_receivewal

• ICU Collation Support

• Push down aggregates to external server

• Trigger Execution Transition Tables

In addition, developers have improved performance in the SUM () function, character encoding conversions, expression evaluations, grouping collections, and connection to unique columns. Google Analytics queries for a large number of rows can be up to 40% faster.

PostgreSQL 10 First Beta release