## E.29. Postgres Pro 9.5.2.1

Release date: 2016-04-01

### E.29.1. Overview

This release is based on PostgreSQL 9.5.2.

Note that Postgres Pro doesn't suffer from abbreviated keys problem, mentioned in the changes of upstream 9.5.2 release. When build with `--with-icu` option, Postgres Pro doesn't use string comparation functions from system C library, and uses portable implementations from libicu.

Major enhancement in the Postgres Pro 9.5.2.1 over Postgres Pro 9.5.1.2 include:

- Include pg_pathman module which provides functions for declarative partitioning and optimizes query execution plans for partitioned tables.

- Include pg_arman incremental backup utlity. It is considered an experimantal feature, so it is build as separate package on Linux and is not available for Windows yet. Documentation is also provided separately

- `version()` SQL function now returns `PostgreSQL 9.5.2`, as in vanilla PostgreSQL, because some client frameworks such as SQL Alchemy are confused seeing Postgres Pro here. Function `pgpro_version` is provided to report Postgres Pro release.