Feeds

PostgreSQL packs record punch

Speedy release

Secure remote control for conventional and virtual desktops

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.®

Providing a secure and efficient Helpdesk

More from The Register

next story
Not appy with your Chromebook? Well now it can run Android apps
Google offers beta of tricky OS-inside-OS tech
Greater dev access to iOS 8 will put us AT RISK from HACKERS
Knocking holes in Apple's walled garden could backfire, says securo-chap
NHS grows a NoSQL backbone and rips out its Oracle Spine
Open source? In the government? Ha ha! What, wait ...?
Google extends app refund window to two hours
You now have 120 minutes to finish that game instead of 15
Intel: Hey, enterprises, drop everything and DO HADOOP
Big Data analytics projected to run on more servers than any other app
New 'Cosmos' browser surfs the net by TXT alone
No data plan? No WiFi? No worries ... except sluggish download speed
prev story

Whitepapers

Providing a secure and efficient Helpdesk
A single remote control platform for user support is be key to providing an efficient helpdesk. Retain full control over the way in which screen and keystroke data is transmitted.
Top 5 reasons to deploy VMware with Tegile
Data demand and the rise of virtualization is challenging IT teams to deliver storage performance, scalability and capacity that can keep up, while maximizing efficiency.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.
Secure remote control for conventional and virtual desktops
Balancing user privacy and privileged access, in accordance with compliance frameworks and legislation. Evaluating any potential remote control choice.