PostgreSQL Group Releases Windows Version of Open-Source Database

 
 
By Lisa Vaas  |  Posted 2005-01-19 Email Print this article Print
 
 
 
 
 
 
 

The PostgreSQL Global Development group on Wednesday released a version of the open-source database PostgreSQL that features better scalability and performance, more features and, most importantly, that supports Windows.

The PostgreSQL Global Development group on Wednesday released a version of the open-source database PostgreSQL that features better scalability and performance, more features and, most importantly, that supports Windows. Besides a community of open-source developers, more than a dozen companies chipped in on development for Version 8.0, including Red Hat Inc., Fujitsu, Afilias Ltd., Software Research Associates Inc., 2nd Quadrant Ltd. and Command Prompt Inc. The support for Windows, a feature customers have been requesting for many years, is widely seen as the most important feature of the new release. "This will really take PostgreSQL to the next level, because Windows seems to be a major deployment platform for open-source [deployment], and theyve been missing out" on that, said Noel Yuhanna, an analyst at Forrester Research Inc., in Santa Clara, Calif.
Native Windows support means that PostgreSQL aficionados will no longer need to run the database with an emulation layer, which will in turn dramatically improve performance. Indeed, it could well be the feature that propels the database out of the realm of developers, who have long embraced it, and into the realm of corporate IT management, Yuhanna said. "I think its popular with the developers, not as much with the mainstream IT organizations," he said. "Commercial DBMSes [database management systems] still hold the key data for most organizations. And the adoption really comes from the developers. Once the developers and administrators start liking the product, start using it and understanding it, then comes the next level, of using it for small, mission-critical deployments, and thats where customers see the advantages" of open-source and of PostgreSQL in particular, he said. Pervasive has packaged PostgreSQL 8 with connectivity drivers and management tools. Read more here.
New features include Savepoints, an SQL-standard feature that allows parts of database transactions to be rolled back instead of aborting entire operations. Point inTime Recovery is another new feature that allows for full data restoration from automatic and continuously archived transaction logs—an alternative to hourly or daily backups. Also new to Version 8 are Tablespaces, which allow for placement of large tables and indexes on individual disks or arrays—a feature that improves query performance and is particularly relevant with large data warehousing systems. Improved memory and I/O have also resulted from the Adaptive Replacement Cache algorithm, a new background writer, and a new vacuum delay feature. Click here for Database Editor Lisa Vaas take on Pervasives seeding of an open-source ecosystem around PostgreSQL. For a complete list of new features, click here. To download the database, go to PostgreSQLs home site. Check out eWEEK.coms for the latest database news, reviews and analysis.
 
 
 
 
Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.
 
 
 
 
 
 
 

Submit a Comment

Loading Comments...

 
Manage your Newsletters: Login   Register My Newsletters























 
 
 
 
 
 
 
 
 
 
 
Rocket Fuel