PostgreSQL 9.5 Brings UPSERT & Big Data Features
Written by Michael Larabel in Free Software on 7 January 2016 at 09:04 AM EST. 7 Comments
PostgreSQL 9.5 was officially released this morning with several exciting new features.

First up, PostgreSQL 9.5 adds UPSERT, a simplified shorthand for doing an INSERT to the database but on conflict to update the record. This PostgreSQL support also eases in migrating legacy MySQL programs to PostgreSQL.

PostgreSQL 9.5 also brings new big data features including BRIN indexing, faster sorts, CUBE / ROLLUP / GROUPING SETS, foreign data wrappers, and TABLESAMPLE.

PostgreSQL 9.5 also brings a new feature of Row-Level Security (RLS) for better per-row and per-column data access control. There are also many other improvements.

More details on PostgreSQL 9.5 can be found via Meanwhile, PostgreSQL 9.6 is already looking bright in development with parallel query support.
Related News
About The Author
Author picture

Michael Larabel is the principal author of and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and automated benchmarking software. He can be followed via Twitter or contacted via

Popular News This Week