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 9.2 Is Faster, Packs In Many New Features

Free Software

Published on 10 September 2012 10:22 PM EDT
Written by Michael Larabel in Free Software
6 Comments

PostgreSQL 9.2 was released earlier today and presents some mighty impressive performance improvements along with other new features.

PostgreSQL 9.2 can scale linearly to 64 cores, index-only scans, advances in lock management, and reduction in CPU power consumption, this new release is much faster and can scale further than before. Read queries can be up by 4x faster, index-only scans for data ware-housing queries can be 2 to 20x faster, and there can be about a 5x improvement in data writes. PostgreSQL 9.2 also supports cascading replications to run larger stacks of horizontally-scaled servers.

PostgreSQL 9.2 also presents native JSON support, covering indexes, range types, and much more. The new PostgreSQL 9.2 features are covered in greater detail on their Wiki what's new page.

More 9.2 release information is available from PostgreSQL.org, including the release notes for this popular open-source database.

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. Scythe Mugen MAX
  2. Intel Core i7 5960X Haswell-E On Linux
  3. Intel 80GB 530 Series M.2 SSD On Linux
  4. With A New Motherboard, The Core i7 5960X Haswell-E Lights Up
Latest Linux Articles
  1. 7-Way Linux Desktop Gaming Comparison On Ubuntu 14.10
  2. Intel P-State vs. CPUFreq Benchmarks On The i7-5960X
  3. RadeonSI GLAMOR Benchmarks With X.Org Server 1.16
  4. RadeonSI Gallium3D vs. Catalyst At 4K UHD On Linux
Latest Linux News
  1. Uselessd: A Stripped Down Version Of Systemd
  2. F2FS Tools Gain FSCK Support
  3. FreeBSD 10.1 Has The New VT Driver, Hardware Improvements
  4. AntiMicro 2.6 Yields Greater Compatibility For Gamepads On Linux
  5. OpenGL 3.3 / GLSL 3.30 Lands For Intel Sandy Bridge On Mesa
  6. AMD's RadeonSI Gallium3D Driver Sees Some Improvements
  7. Mesa 10.3 Released With The Latest Open-Source GPU Driver Improvements
  8. GNOME 3.13.92 Officially Released
  9. Wine 1.7.27 Is Still Working Towards Direct2D Support
  10. Wasteland 2 Officially Launched Today, Including For Linux Gamers
Latest Forum Discussions
  1. SSD seems slow
  2. X.Org Women Outreach Program Only Turns Up Two Applicants So Far
  3. R. Tyler restarts work on FreeBSD launchd port, openlaunchd
  4. Can Linux kill a motherboard?
  5. Stop grabbing my keyboard :(
  6. Glamor now enabled in Debian radeonsi
  7. New stress testing utility for GPU's
  8. New Group Calls For Boycotting Systemd