Articles & Reviews
News Archive
Forums
Premium
Contact
Categories

Computers Display Drivers Graphics Cards Linux Gaming Memory Motherboards Processors Software Storage Operating Systems Peripherals

PostgreSQL 9.4 Brings JSONB & Many Other New Features

Written by Michael Larabel in Free Software on 18 December 2014 at 10:47 AM EST. Add A Comment

PostgreSQL 9.4 is out in time for Christmas with numerous changes for users of this open-source database solution.

PostgreSQL 9.4 delivers the new JSONB / binary JSON data type for storing JSON data within PostgreSQL. The 9.4 release also brings the new Data Change Streaming API for decoding/transformation of the replication stream. There's also new ALTER STREAM and ALTER TABLESPACE ... MOVE commands, a FILTER clause for aggregate functions, write scalability improvements, time-delayed standbys, backup throttling, and numerous other enhancements.

More details on PostgreSQL 9.4 via the official announcement and the changes for 9.4 are listed at length via the PostgreSQL Wiki.

Add A Comment

Tow-Boot 2023.07 U-Boot Distribution Released With New Board Support

Valkey Celebrates Its First Stable Release As Open-Source Redis Fork

Servo Driving Modularity To Support Different JavaScript Engines

Vim Lands XDG Base Directory Specification Support

OpenJPH 0.11 Works Toward Low-Latency High-Throughput JPEG-2000 (HTJ2K)

About The Author

Michael Larabel is the principal author of Phoronix.com 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 OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter, LinkedIn, or contacted via MichaelLarabel.com.