[FSUG PD] A chi piaciono di DB -> [ANNOUNCE] PostgreSQL 10 Released

[Emanuele Zamprogno]

Un buongiornissimo a tutti!

Mi permetto di girare questa notizia che da poco è disponibile e penso
potrà interessare tutti coloro che direttamente o indirettamente
bazzicano fra DB e famigli.

Faccio inoltre notare come, visto il numero della major release, si
tratta di uno dei progetti fra i più longevi del panorama FLOSS, se non
il più longevo in ambito DB.

Si ringrazia chiunque vorrà commentare, postare, redistribuire la news

Un saluto,

Emanuele.


-------- Messaggio Inoltrato --------
Oggetto: 	[ANNOUNCE] PostgreSQL 10 Released
Data: 	Thu, 5 Oct 2017 15:28:48 +0100
Mittente: 	Dave Page <dpage a postgresql.org>
A: 	pgsql-announce <pgsql-announce a postgresql.org>



The PostgreSQL Global Development Group today announced the release of
PostgreSQL 10, the latest version of the world's most advanced open
source database.

A critical feature of modern workloads is the ability to distribute data
across many nodes for faster access, management, and analysis, which is
also known as a "divide and conquer" strategy. The PostgreSQL 10 release
includes significant enhancements to effectively implement the divide
and conquer strategy, including native logical replication, declarative
table partitioning, and improved query parallelism.

"Our developer community focused on building features that would take
advantage of modern infrastructure setups for distributing workloads,"
said Magnus Hagander, a core team
(https://www.postgresql.org/developer/core/) member of the PostgreSQL
Global Development Group (https://www.postgresql.org/). "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 a "x.y" format.  This means the next minor release of
PostgreSQL will be 10.1 and the next major release will be 11.

* Logical Replication - A publish/subscribe framework for distributing
data  

Logical replication extends the current replication features of
PostgreSQL with the ability 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.

"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
(https://www.yandex.com/).  

* Declarative Table Partitioning - Convenience in dividing your data  

Table partitioning has existed for years in PostgreSQL but required a
user to maintain a nontrivial 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.  

* Improved Query Parallelism - Quickly conquer your analysis  

PostgreSQL 10 provides better support for parallelized queries by
allowing more parts of the query execution process to be parallelized. 
Improvements include additional types of data scans that are
parallelized as well as optimizations when the data is recombined, such
as pre-sorting. These enhancements allow results to be returned more
quickly.  

* Quorum Commit for Synchronous Replication - Distribute data with
confidence  

PostgreSQL 10 introduces quorum commit for synchronous replication,
which allows for flexibility in how a primary database receives
acknowledgement that changes were successfully written to remote
replicas.  An administrator can now specify that if any number of
replicas has acknowledged that a change to the database has been made,
then the data can be considered safely written.

"Quorum commit for synchronous replication in PostgreSQL 10 gives more
options to extend our ability to promote database infrastructure with
nearly zero downtime from the application perspective. This allows us to
continuously deploy and update our database infrastructure without
incurring long maintenance windows," said Curt Micol, Staff
Infrastructure Engineer at Simple Finance (https://www.simple.com/).  

* SCRAM-SHA-256 authentication - Secure your data access  

The Salted Challenge Response Authentication Mechanism (SCRAM) defined
in RFC5802 (https://tools.ietf.org/html/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
(https://tools.ietf.org/html/rfc7677), to provide better security than
the existing MD5-based password authentication method.

Links
-----

* Downloads (https://www.postgresql.org/downloads)
* Press Kit (https://www.postgresql.org/about/press/presskit10)
* Release Notes
(https://www.postgresql.org/docs/current/static/release-10.html)
* What's New in 10 (https://wiki.postgresql.org/wiki/New_in_postgres_10)

About PostgreSQL
----------------

PostgreSQL is the world's most advanced open source database, with a
global community of thousands of users, contributors, companies and
organizations.  The PostgreSQL Project builds on over 30 years of
engineering, starting at the University of California, Berkeley, and has
continued with an unmatched pace of development. PostgreSQL's mature
feature set not only matches top proprietary database systems, but
exceeds them in advanced database features, extensibility, security and
stability.  Learn more about PostgreSQL and participate in our community
at PostgreSQL.org (https://www.postgresql.org).


-- 
Dave Page
PostgreSQL Core Team
http://www.postgresql.org/