Specifically for PostgreSQL version 9.5

Version details

  1. Version: 9.5

  2. Version type: major.

  3. Released: January 2016.

  4. EOL: January 2021 (in accordance with Postgres 5 year rule).

New features highlight

Far from complete list, only few chosen from across whole (long) list:

  1. Conclicting INSERTs now may be ignored or turned into UPDATEs

  2. Block Range INdex added (BRIN)

  3. High number of performance changes

  4. ALTER SYSTEM RESET (resets value in postgresql.auto.conf file)

Complete list linked below.


  1. http://www.postgresql.org/support/versioning/

  2. http://www.postgresql.org/docs/9.5/static/release-9-5.html