Feeds

PostgreSQL packs record punch

Speedy release

Application security programs and practises

The latest release of open source database PostgreSQL hit Monday, packing a claimed record number of new and improved features. That means 280 patches.

Version 8.3 of the sturdy alternative to MySQL has been re-worked for developers, DBAs and users with improvements targeting performance and maintenance.

Among the changes, Heap Only Tuples (HOT) that may cut the maintenance overhead of frequently updated tables by up to 75 per cent, spread checkpoints and background writer autotuning to reduce the impact of check points on response times, and an asynchronous commit option that also speeds the response times of certain transactions.

The PostgreSQL Global Development Group claims these changes contribute to an overall boost in transaction processing output of between five and thirty percent - depending on workload, naturally.

Developers get treated to ANSI-standard SQL-XML support, improved search and support for new data types.

The full list of all features in version 8.3 can be found here, source code is here, binaries here, and other bits and bobs here.

The release comes as Sun Microsystems begins to digest MySQL, while also offering a distribution of PostgreSQL with Solaris. Sun software executive vice president Rich Green gave his blessing to PostgreSQL 8.3, calling the database an "impressive new release" the he encourages customers to explore.®

The smart choice: opportunity from uncertainty

More from The Register

next story
HIDDEN packet sniffer spy tech in MILLIONS of iPhones, iPads – expert
Don't panic though – Apple's backdoor is not wide open to all, guru tells us
Do YOU work at Microsoft? Um. Are you SURE about that?
Nokia and marketing types first to get the bullet, says report
Microsoft takes on Chromebook with low-cost Windows laptops
Redmond's chief salesman: We're taking 'hard' decisions
Cheer up, Nokia fans. It can start making mobes again in 18 months
The real winner of the Nokia sale is *drumroll* ... Nokia
EU dons gloves, pokes Google's deals with Android mobe makers
El Reg cops a squint at investigatory letters
Chrome browser has been DRAINING PC batteries for YEARS
Google is only now fixing ancient, energy-sapping bug
Big Blue Apple: IBM to sell iPads, iPhones to enterprises
iOS/2 gear loaded with apps for big biz ... uh oh BlackBerry
prev story

Whitepapers

Reducing security risks from open source software
Follow a few strategies and your organization can gain the full benefits of open source and the cloud without compromising the security of your applications.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
Application security programs and practises
Follow a few strategies and your organization can gain the full benefits of open source and the cloud without compromising the security of your applications.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Consolidation: the foundation for IT and business transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.