PostgreSQL Group Releases Windows Version of Open-Source DatabaseBy Lisa Vaas | Posted 2005-01-19 Email 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 they've been missing out" on that, said Noel Yuhanna, an analyst at Forrester Research Inc., in Santa Clara, Calif.
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 it's 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 that's where customers see the advantages" of open-source and of PostgreSQL in particular, he said.
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 logsan 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 arraysa 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.
Check out eWEEK.com's for the latest database news, reviews and analysis.