November 20, 2003
PostgreSQL boosts open source database
Data warehousing, Opteron optimization cited
Recommend ThisPostgreSQL Global Development Group this week is shipping Version 7.4 of its open source PostGreSQL Object Relational Database Management System.
Data warehousing functionality has been improved in the product through executer improvements that allow analysis queries to run faster, according to Bruce Momjian, a PostgreSQL representative. The database is attracting converts from commercially available products, Momjian said.
"People in our community [are] moving over from Oracle, Informix," and other databases, he said.
Saying the product provides commercial-grade enterprise database functionality with low cost of ownership, the company is including new features such as AMD Opteron optimization, improved index maintenance tools, and enhanced support of full text indexing to add ranked result sets.
To improve query and procedure performance, the company also has added hash aggregation in memory, query planner improvement for subqueries, a new wire protocol, and expanded functional and expressional indexes.
ANSI SQL standard compliance has been enhanced through an overhaul of messaging internals and improved metadata reporting. Online documentation has been reorganized and expanded. GUI tools functioning with the product also has been improved.
The database is offered free of charge. Online community support also is free. Companies such as Software Research Associates can provide commercial support, Momjian said.
Paul Krill is an editor at large at InfoWorld.
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 »
- Upgrading to VMware vSphere with vWire | White Paper
- Removing Barriers To Better Server Virtualization Efficiency | White Paper
- Oracle Business Brief - Keeping hold of your customers, especially in tough economic conditions | White Paper
- Analytics Partners - Delivering Faster and More Strategic BI | White Paper
- From Chaos to Order: Winning the Information Management Game | White Paper
Sign up to receive Data Management Resource Alerts
Make IT work as one. Register for Novell BrainShare 2010. Complimentary Energy Efficiency Kit - Cut Energy Costs NowRestrict 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
Return on Information: Google Enterprise Search pays you back. Get the facts.Analytics: Use your data to drive insights that enable better decisions.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.
