[$] "Big data" features coming in PostgreSQL 9.5 PostgreSQL 9.5 Alpha 2 is due to be released on August 6. Not only
does the new version support UPSERT, more JSON functionality, and other new
features we
looked at back in July, it also
has some major enhancements for "big data" workloads. Among these are
faster sorts,
TABLESAMPLE,
GROUPING SETS and
CUBE, BRIN indexes, and Foreign Data Wrapper improvements. Taken
together, these features strengthen arguments for using PostgreSQL for data
warehouses, and enable users to continue using it with bigger databases.