E.14. Postgres Pro Enterprise 9.6.6.3

E.14.1. Overview

Release date: 2018-01-17

E.14.1. Overview

This release is based on Postgres Pro Enterprise 9.6.6.2. 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 60.3.

  • Updated RUM index to version 1.2 (See Section F.55.)

    • 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.