Release date: 2018-01-17
This release is based on Postgres Pro Standard 9.6.6.1 and Postgres Pro Enterprise 9.6.6.2. All improvements inherited from Postgres Pro Standard 9.6.6.1 are listed in Postgres Pro Standard 9.6.6.1 Release Notes.
Major enhancements over Postgres Pro Enterprise 9.6.6.2 include:
Improved multimaster extension. In particular, the following changes were introduced:
Fixed rules of resolving stale prepared transactions after a node failure.
Fixed errors that occurred when selecting transactions to apply during automatic recovery process.
TRUNCATE operations now do not cause global cluster locks.
Sped up node status switches.
Referee decision is now preserved after rebooting the nodes that won the referee voting.
Updated pg_pathman module to version 1.4.9. For a full list of changes, see pg_pathman Wiki.
Added several fixes for 64-bit XIDs.
Improved k-NN support:
Fixed the execution of the following query types with a btree index:
SELECT * FROM tab WHERE col IN (1,2,3) ORDER BY col <-> 4
Added cross-type distance operators, such as int2 <-> int4, float4 <-> float8, date <-> timestamp, etc.
Added the ammatchorderbyop method.
Enabled distance recheck for SP-GiST indexes.
For details, see the description of the leaf_consistent
function in Section 61.3.
Updated RUM index to version 1.2 (See Section F.57.)
Added support for the anyarray type via rum_anyarray_ops and rum_anyarray_addon_ops operator classes.
Updated pg_probackup utility to version 2.0.14.
Fixed race conditions in ptrack and page backups.
Fixed parallel ptrack backup interruption.
Added new backup state ORPHAN, which indicates
that one of previous backups is corrupted.