Open Source PostgreSQL 8.3 Better Suited For Web Applications - InformationWeek
Software // Information Management
10:07 PM
Connect Directly
Building Security for the IoT
Nov 09, 2017
In this webcast, experts discuss the most effective approaches to securing Internet-enabled system ...Read More>>

Open Source PostgreSQL 8.3 Better Suited For Web Applications

New features include a full text search tool, improved overall throughput, and ANSI standard SQL/XML support.

The 8.3 release of the PostgreSQL open source database moved out of beta into general availability this week as its development team put the finishing touches to performance enhancements, full text search, and more efficient garbage collection.

Sun Microsystems' Rich Green, executive VP of software, said the 8.3 release "is an impressive new release and we encourage customers around the world to explore it." Sun has provided commercial technical support for PostgreSQL, distributes it with its Java middleware, and employs several full time PostgreSQL contributors, including Josh Berkus, in San Francisco. Sun has maintained its PostgreSQL support after announcing the purchase of MySQL AB, maker of the MySQL open source database for $800 million plus an estimated $200 million for stock options.

The features of the 8.3 release became available for beta testing after Labor Day, but have now been finalized. Berkus said they include the full text search tool, TSearch2, now merged into the core database with new dictionaries and languages. Text searching was previously available as an optional add-on module.

PostgreSQL has improved overall throughput by cutting down on the maintenance overhead in its operations, including transaction throughput. The system formerly paused frequently to clean up rows of data that were no longer being used. PostgreSQL generates versions of rows based on user queries and updates, and retains rows that have become outdated in case they are needed for a back up or transaction recovery. Because of that, it frequently re-indexed tables, "which sucked a fair amount of performance out of the database," said Berkus. Excess row maintenance and re-indexing have been eliminated in the 8.3 release, he said.

That means that the database will perform more predictably, regardless of the variety of tasks, while it was previously more difficult to ensure predictable performance. "The bigger message is performance consistency," not database speed up, Berkus said.

PostgreSQL also can gang up similar queries so that more than one can be addressed during a full scan of a database table, another performance enhancer. That means PostgreSQL, when used for data warehouse or other large database purposes, should be able to return answers to queries on a 10 Tbyte system with the same speed that it used to address a 5 Tbyte database, he said.

The PostgreSQL development team also has added ANSI standard SQL/XML support, including the ability to retrieve data with an XML export command. The command converts the sought-after data to XML and can swap it directly with another database seeking XML data, rather than processing relational data through middleware to convert it into XML. The feature will be useful for Web applications that want to retrieve XML text and documents instead of relational data, Berkus said.

Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
2017 State of IT Report
In today's technology-driven world, "innovation" has become a basic expectation. IT leaders are tasked with making technical magic, improving customer experience, and boosting the bottom line -- yet often without any increase to the IT budget. How are organizations striking the balance between new initiatives and cost control? Download our report to learn about the biggest challenges and how savvy IT executives are overcoming them.
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll