PostgreSQL 9.5 Brings UPSERT & Big Data 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 PostgreSQL.org. Meanwhile, PostgreSQL 9.6 is already looking bright in development with parallel query support.
7 Comments
