opendbteam workspace

opendbteam workspace
opendbteam workspace

Tuesday, July 28, 2015

New #PostgreSQL 9.5 #archiving feature to come

For those of you who would like to perpetually archive, good news: it might just be possible with a new parameter.

#PostgreSQL #9.5 Alpha 1 released

The future new version is right on track, with previews of all features, such as:
Block-Range Indexes (BRIN) which enable compact indexing of very large tables
Large speed improvements in in-memory sorting and hashing
Automated management of transaction log size
INSERT ON CONFLICT UPDATE, otherwise known as “UPSERT”
Grouping Sets, CUBE and ROLLUP analytic operations
Row-Level Security (RLS) support
More JSONB data manipulation functions and operators
Added the pg_rewind tool and other high availability improvements to replication
Multiple enhancements to Foreign Data Wrappers, including IMPORT FOREIGN SCHEMA
Large increases in multi-core and large memory scalability
Beta version to be released in August.