"Our developer community focused on building features that would take advantage of modern infrastructure setups for distributing workloads," said Magnus Hagander, a core team member of the PostgreSQL Global Development Group. "Features such as logical replication and improved query parallelism represent years of work and demonstrate the continued dedication of the community to ensuring Postgres leadership as technology demands evolve."
This release also marks the change of the versioning scheme for PostgreSQL to an "x.y" format. This means the next minor release of PostgreSQL will be 10.1 and the next major release will be 11.
The new logical replication feature provides the capability to send modifications on a per-database and per-table level to different PostgreSQL databases. Users can now finetune the data replicated to various database clusters and will have the ability to perform zero-downtime upgrades to future major PostgreSQL versions.
"We have been heavily using PostgreSQL since 9.3 and are very excited about version 10 since it brings basis for long-awaited partitioning and built-in logical replication. It will allow us to use PostgreSQL in even more services," said Vladimir Borodin, DBA Team Lead at Yandex, a Russian machine learning specialist with offices in China, Kazakhstan and Turkey.
Table partitioning has existed for years in PostgreSQL but required a user to maintain a set of rules and triggers for the partitioning to work. PostgreSQL 10 introduces a table partitioning syntax that lets users easily create and maintain range and list partitioned tables. The addition of the partitioning syntax is the first step in a series of planned features to provide a robust partitioning framework within PostgreSQL.
PostgreSQL 10 also provides better support for parallelised queries by allowing more parts of the query execution process to be parallelised. Improvements include additional types of data scans that are parallelised as well as optimisations when the data is recombined, such as pre-sorting. These enhancements allow results to be returned more quickly.
PostgreSQL 10 further adds flexibility in how a primary database receives acknowledgement that changes were successfully written to remote replicas. An administrator can now specify that if a specific number of replicas have acknowledged that a change to the database has been made, then the data can be considered safely written.
PostgreSQL 10 is also more secure. The Salted Challenge Response Authentication Mechanism (SCRAM) defined in RFC5802 defines a protocol to improve upon the secure storage and transmission of passwords by providing a framework for strong password negotiation. PostgreSQL 10 introduces the SCRAM-SHA-256 authentication method, defined in RFC7677, to provide better security than the existing MD5-based password authentication method.
Explore:
Downloads and release notes
This release also marks the change of the versioning scheme for PostgreSQL to an "x.y" format. This means the next minor release of PostgreSQL will be 10.1 and the next major release will be 11.
The new logical replication feature provides the capability to send modifications on a per-database and per-table level to different PostgreSQL databases. Users can now finetune the data replicated to various database clusters and will have the ability to perform zero-downtime upgrades to future major PostgreSQL versions.
"We have been heavily using PostgreSQL since 9.3 and are very excited about version 10 since it brings basis for long-awaited partitioning and built-in logical replication. It will allow us to use PostgreSQL in even more services," said Vladimir Borodin, DBA Team Lead at Yandex, a Russian machine learning specialist with offices in China, Kazakhstan and Turkey.
Table partitioning has existed for years in PostgreSQL but required a user to maintain a set of rules and triggers for the partitioning to work. PostgreSQL 10 introduces a table partitioning syntax that lets users easily create and maintain range and list partitioned tables. The addition of the partitioning syntax is the first step in a series of planned features to provide a robust partitioning framework within PostgreSQL.
PostgreSQL 10 also provides better support for parallelised queries by allowing more parts of the query execution process to be parallelised. Improvements include additional types of data scans that are parallelised as well as optimisations when the data is recombined, such as pre-sorting. These enhancements allow results to be returned more quickly.
PostgreSQL 10 further adds flexibility in how a primary database receives acknowledgement that changes were successfully written to remote replicas. An administrator can now specify that if a specific number of replicas have acknowledged that a change to the database has been made, then the data can be considered safely written.
PostgreSQL 10 is also more secure. The Salted Challenge Response Authentication Mechanism (SCRAM) defined in RFC5802 defines a protocol to improve upon the secure storage and transmission of passwords by providing a framework for strong password negotiation. PostgreSQL 10 introduces the SCRAM-SHA-256 authentication method, defined in RFC7677, to provide better security than the existing MD5-based password authentication method.
Explore:
Downloads and release notes
No comments:
Post a Comment