## E.18. Postgres Pro Enterprise 9.6.6.3

Release date: 2018-01-17

### E.18.1. Overview

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