SDA India is an online resource for Software, Development,IT, Architecture, Open Source, Mobile, Security, Databases, Delphi, C, OS, Asp, .Net, Php, Xml, Java
From the News Desk
Thursday, 7. February 2008
PostgreSQL 8.3- Open Source Database is Out
The PostgreSQL, open source relational database system has released version 8.3. This release includes a record number of new and improved features to enhance PostgreSQL for application designers, database administrators, and users. PostgreSQL is distributed under a BSD license, which allows use and distribution without fees for both commercial and non-commercial applications.
Rich Green, executive vice president of software at Sun Microsystems, said “continued evolution of the open source PostgreSQL database gives users the option of deploying a non-proprietary database.”
Version 8.3 ensures high performance and the performance enhancements include:
· Heap Only Tuples (HOT)
· Spread checkpoints and background writer auto tuning
· Asynchronous commit option for much faster response times on some transactions
PostgreSQL implements Synchronized Scan, which reduces I/O for data mining. The Windows team has enabled Visual C++ compilation of PostgreSQL, improving stability and performance on Windows, as well as accessibility to the project to Windows contributors. New logging options have been added and the overhead of the statistics collector has been diminished in order to make it easier to monitor the servers. The new features for application developers, including:
· ANSI-standard SQL/XML support, including XML export
· Text search
· GSSAPI and SSPI authentication support
· New data types including UUIDs, ENUMs and arrays of composite types
Related Links
PostgreSQL
Rich Green, executive vice president of software at Sun Microsystems, said “continued evolution of the open source PostgreSQL database gives users the option of deploying a non-proprietary database.”
Version 8.3 ensures high performance and the performance enhancements include:
· Heap Only Tuples (HOT)
· Spread checkpoints and background writer auto tuning
· Asynchronous commit option for much faster response times on some transactions
PostgreSQL implements Synchronized Scan, which reduces I/O for data mining. The Windows team has enabled Visual C++ compilation of PostgreSQL, improving stability and performance on Windows, as well as accessibility to the project to Windows contributors. New logging options have been added and the overhead of the statistics collector has been diminished in order to make it easier to monitor the servers. The new features for application developers, including:
· ANSI-standard SQL/XML support, including XML export
· Text search
· GSSAPI and SSPI authentication support
· New data types including UUIDs, ENUMs and arrays of composite types
Related Links
PostgreSQL
