Feeds

PostgreSQL packs record punch

Speedy release

The essential guide to IT transformation

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 essential guide to IT transformation

More from The Register

next story
Microsoft boots 1,500 dodgy apps from the Windows Store
DEVELOPERS! DEVELOPERS! DEVELOPERS! Naughty, misleading developers!
Apple promises to lift Curse of the Drained iPhone 5 Battery
Have you tried turning it off and...? Never mind, here's a replacement
Mozilla's 'Tiles' ads debut in new Firefox nightlies
You can try turning them off and on again
Linux turns 23 and Linus Torvalds celebrates as only he can
No, not with swearing, but by controlling the release cycle
Scratched PC-dispatch patch patched, hatched in batch rematch
Windows security update fixed after triggering blue screens (and screams) of death
This is how I set about making a fortune with my own startup
Would you leave your well-paid job to chase your dream?
prev story

Whitepapers

5 things you didn’t know about cloud backup
IT departments are embracing cloud backup, but there’s a lot you need to know before choosing a service provider. Learn all the critical things you need to know.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Backing up Big Data
Solving backup challenges and “protect everything from everywhere,” as we move into the era of big data management and the adoption of BYOD.
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.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?