E.22. Postgres Pro

Release date: 2016-04-01

E.22.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 comparison functions from system C library, and uses portable implementations from libicu.

Major enhancement in the Postgres Pro over Postgres Pro include:

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

  • Include pg_arman incremental backup utility. It is considered an experimental 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.