July 01, 2009
PostgreSQL 8.4 released, focus on admin, monitoring
8 RecommendationsThe PostgreSQL project has released version 8.4 of its namesake open source database system with some 300 new or improved features and a renewed focus on administration and monitoring tools.
PostgreSQL is used by thousands of organisations worldwide and is often regarded as the "enterprise grade" open source database compared with the more popular MySQL.
[ Track the latest trends in open source with InfoWorld's Open Sources blog and Technology: Open Source newsletter. ]
Notable enhancements in version 8.4 include parallel database restore for speeding up recovery from backup (by up to eight times); per-column permissions for more granular control of sensitive data; and per-database collation support to make PostgreSQL more useful in multi-lingual environments.
PostgreSQL users include IMAN international, All Homes and shopping centre giant Westfield.
Also new in 8.4 is in-place upgrades through pg_migrator (beta) to enable upgrades from 8.3 to 8.4 without "extensive" downtime and new query monitoring tools to give administrators more insight into query activity.
Kevin Grittner, database administrator for the Wisconsin courts system, said the new release boosts application performance.
"Version 8.4 has added several optimisations, such as semi-joins and anti-joins, which provide dramatic improvement in the run time of some of our most demanding queries," Grittner said.
According to the developers, version 8.4 makes data analysis easier through the advanced ANSI SQL2003 features of windowing functions, common table expressions and recursive joins.
Jeffrey Webster, CTO of ZooLoo.com, said: "We've used PostgreSQL for seven years now, and we're really looking forward to many of the features in 8.4, particularly column permissions, per-database locale, partial matches for GIN indexes and user defined exceptions. PostgreSQL has allowed us to grow without sacrificing data integrity."
The OpenStreetMap project is also a PostgreSQL user.
OpenStreetMap system administrator Tom Hughes said when the mapping service was planning the new version of its API, it needed a world-class database that runs well at the scale it needs.
PostgreSQL 8.4 can be downloaded from www.postgresql.org and the full list of 8.4 features is also online.
White Paper
D2D Virtual Tape Library Replication Primer
This whitepaper explains the terminology and concepts behind Data Replication technologies and establishes some sizing rules through worked examples. Learn the new paradigm in disaster tolerance—protect data anywhere.
Download now »
White Paper
An Alternative to Virtualization for Datacenter Cost Savings
Server virtualization is a popular option for dealing with mounting datacenter costs. Another equally promising approach is the use of an Application Delivery Controller. Citrix NetScaler provides a low-cost way for organizations to reduce their server count and accrue cost savings from a reduction in space, cooling, power and personnel.
Download now »
White Paper
Why Your Firewall, VPN, and IEEE 802.11i Aren't Enough to Protect Your Network
The emergence of WLANs has created a new breed of security threats to enterprise networks.
Included in HP ProCurve WLAN solutions is security technology that alleviates threats from WLANs through:
* Monitoring wireless activity inside and out of the enterprise
* Classifying WLAN transmissions into harmful and harmless
* Preventing transmissions that pose a security threat to the enterprise network
* Locating participating devices for physical remediation
White Paper
Bringing the Edge to the Data Center
Effectively address data protection challenges, implementing solutions that help store and protect business–critical data while cutting costs and improving efficiency and reliability.
Download now »
- Tackling the Top Five Network Access Control Challenges | White Paper
- Opportunities and Challenges with the Convergence of Data Center Networks | White Paper
- Network Operating System Evolution | White Paper
- How Operating Systems Create Network Efficiency | White Paper
- Data Center Survival Guide | White Paper
Sign up to receive InfoWorld Resource Alerts
Return on Information: Google Enterprise Search pays you back. Get the facts.Analytics: Use your data to drive insights that enable better decisions.Restrict internet access with GFI WebMonitor™. Now 30% Off! www.gfi.com/web-filterToday’s IT means business. New eBook shows you how to align your IT investments.A new level of interoperability. Make IT Work As One at novell.comLimited-time offer: Save up to $100 on Polycom phones. 64-page prescriptive guide to security, compliance, and IT operations.Learn about Foundations of Green IT, from CTO Marty Poniatowski802.11n Drives an Architectural EvolutionSee IBM CloudBurst's self-service user interface in action
Complimentary Energy Efficiency Kit - Cut Energy Costs NowSuper Multi NAS devices from LG
See how AT&T can help protect your network. Make IT Work As One at novell.comHP ProLiant G6 Servers. Perform like a superstar, Save like an accountant.HP ProLiant G6 Servers. Perform like a superstar, Save like an accountant.Unified Communications: Thoughts, Strategies and Predictions. Join the discussion.Increase UPS efficiency without sacrificing protectionIn less than 45 minutes, Palisade Systems protects your dataA smarter approach to IT is needed. That smarter approach is IBM CloudBurst.
