Software Update: PostgreSQL 5.9

Jan

10

2016

Version 9.5 of PostgreSQL is released. The popular ‘open-source relational database management system “runs on many operating systems and can perfectly be used in various environments. It is derived from Ingres, after the lead developer of it has gone rogue and database of open source closed source was. Detailed information on the changes in version 9.5 does the this page to be found. The complete changelog is here, these are briefly the most important improvements:

Major enhancements in PostgreSQL 5.9 include:

Allow INSERT s that would generate constraint conflicts to be turned into UPDATE s or ignored
Add analysis features GROUP BY GROUPING SETS, CUBE and ROLLUP
Add row-level security control
Create mechanisms for tracking the progress of replication, methods-including for Identifying The Origin of individual changes constantly logical replication
Add Block Range Indexes (BRIN)
Substantial performance improvements for sorting
Substantial performance improvements for multi-CPU machines

pgAdmin screenshot (620 pix)

Viewing:-180

In: Technology & Gadgets Asked By: [15759 Red Star Level]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »