As a member of the PostgreSQL Global Development Group, we would like to congratulate the community for announcing today the release of PostgreSQL 10, the latest version of the world's most advanced open source database.
PostgreSQL is a popular option for organisations requiring an enterprise scale RDBMS without the costs associated with traditional proprietary platforms. The release of PostgreSQL 10 delivers DBAs multiple enhancements and demonstrates the Postgres community's dedication to respond to user requests and rapid evolution in technology.
PostgreSQL 10 takes full advantage of enterprise data infrastructure to distribute workloads across many nodes for faster access, management, and analysis, employing a "divide and conquer" strategy. This is achieved thanks to the development of features including logical replication, declarative table partitioning, and improved query parallelism among others.
As a publish/subscribe framework for distributing data, Logical Replication enables greater flexibility than physical replication, including replication between different notable versions of PostgreSQL and selective-table replication. It extends the current PostgreSQL features to send modifications on a per-database and per-table level to different PostgreSQL databases. Users can now fine-tune the data replicated to various database clusters and will have the ability to perform zero-downtime upgrades to future major PostgreSQL versions.
Improved Query Parallelism
Results are returned more quickly with PostgreSQL 10 providing greater support for parallelised queries. Now more parts of the query execution process can be parallelised enabling additional types of data scans as well as optimisations when the data is recombined, such as pre-sorting.
Quorum Commit for Synchronous Replication
DBAs can now distribute data with even greater confidence, by specifying the minimum number of replicas that is needed to acknowledge, that the data has been safely replicated.
Declarative Table Partitioning
Dividing your data is now easier than ever before. PostgreSQL 10 introduces a table partitioning syntax that lets users create and maintain range and list partitioned tables effortlessly. This is the first step in a series of planned features to provide a robust partitioning framework within PostgreSQL going forward.
Administrators can secure data access with the new SCRAM-SHA-256 authentication method, defined in RFC7677. This protocol provides a framework for strong password negotiation to improve on the secure storage and transmission of passwords over the existing MD5-based password authentication method.
Release Naming Scheme
This release marks the change of the versioning scheme for PostgreSQL to an "x.y" format meaning the next minor release of PostgreSQL will be 10.1 and the next major release will be 11.
Fujitsu is proud to be a part of the PostgreSQL community and has been contributing to the development of PostgreSQL since 2004. We provide complete end-to-end PostgreSQL-based solutions with a wide range of services including support, migration, health check, operations review, training and consulting, all from a global vendor with extensive database expertise and credentials for commercial peace of mind.
Our team are available now to provide support for PostgreSQL 10.
PostgreSQL 10 is available immediately from the PostgreSQL community download page.
We also provide an enhanced edition with FUJITSU Enterprise Postgres for a greater level of enterprise features and support.