1. Computers
  2. Display Drivers
  3. Graphics Cards
  4. Memory
  5. Motherboards
  6. Processors
  7. Software
  8. Storage
  9. Operating Systems


Facebook RSS Twitter Twitter Google Plus


Phoronix Test Suite

OpenBenchmarking.org

PostgreSQL Gains Support For Logical Decoding

Free Software

Published on 04 March 2014 11:38 AM EST
Written by Michael Larabel in Free Software
1 Comment

PostgreSQL has picked up a new feature of logical decoding.

This new PostgreSQL database feature adds over ten thousand lines of new code to the open-source server and allows the write-ahead log stream to be decoded into a series of logical changes, per this commit.

PostgreSQL's logical decoding feature is more elegantly described via this mailing list post:
This feature, building on previous commits, allows the write-ahead log stream to be decoded into a series of logical changes; that is, inserts, updates, and deletes and the transactions which contain them. It is capable of handling decoding even across changes to the schema of the effected tables. The output format is controlled by a so-called "output plugin"; an example is included. To make use of this in a real replication system, the output plugin will need to be modified to produce output in the format appropriate to that system, and to perform filtering.

Currently, information can be extracted from the logical decoding system only via SQL; future commits will add the ability to stream changes via walsender.
Look for logical decoding to appear in the PostgreSQL 9.4 release.

About The Author
Michael Larabel is the principal author of Phoronix.com and founded the web-site in 2004 with a focus on enriching the Linux hardware experience and being the largest web-site devoted to Linux hardware reviews, particularly for products relevant to Linux gamers and enthusiasts but also commonly reviewing servers/workstations and embedded Linux devices. Michael has written more than 10,000 articles covering the state of Linux hardware support, Linux performance, graphics hardware drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated testing software. He can be followed via and or contacted via .
Latest Linux Hardware Reviews
  1. ASRock X99 Extreme3 Is An Affordable Choice For Linux Users
  2. A Walkthrough Of The New 32 System Open-Source Linux Benchmarking Test Farm
  3. Habey MITX-6771: Mini-ITX Board With Quad-Core J1900 Bay Trail
  4. OCZ Vector 150 SSD On Linux
Latest Linux Articles
  1. 17-Way Linux Graphics Card Comparison With Civilization Beyond Earth
  2. AMD Kaveri: Open-Source Radeon Gallium3D vs. Catalyst 14.12 Omega Driver
  3. 12-Way AMD Catalyst 14.12 vs. NVIDIA 346 Series Linux GPU Comparison
  4. AMD Catalyst 14.12 Omega Driver Brings Mixed Results For Linux Users
Latest Linux News
  1. NTP Is The Latest Project Struck By Security Issues
  2. LDC 0.15.1 Released For A D Compiler In LLVM
  3. Fedora Doesn't Yet Enable F2FS File-System Support
  4. XZ 5.2 Adds New Multi-Threaded Options
  5. Intel 2.99.917 X.Org Driver Released, 3.0 Release Finally Near
  6. Server-Side XCB Is Being Discussed For The X.Org Server
  7. Adreno A4xx Rendering With Freedreno Takes Shape
  8. Linux 3.19-rc1 Kernel Released Ahead Of Schedule
  9. X.Org Server 1.16.3 Released To Fix Security Issues
  10. Linux 3.19 Merge Window Closes Ahead Of Schedule
Latest Forum Discussions
  1. Need some hand holding with upgrading xserver
  2. Maker3D - create your 3D RPG
  3. FPS capped on Linux (AMD fglrx drivers)
  4. Looking for an nVidia GPU, but not sure how well they are supported.
  5. Speeding up systemd networking service
  6. Major Performance Breakthrough Discovered For Intel's Mesa Driver
  7. Are there an app using HSA ?
  8. The New SuperTuxKart Looks Better, But Can Cause GPU/Driver Problems