PostgreSQL Database server version 8.1.1 is now available
Designed, built and tested by a large and thriving community and backed by a growing number of corporate sponsors and support companies, version 8.1.1 will expand the scope of PostgreSQL application development. The new release includes performance imp
2005-12-15 00:00:00 2005-12-15 00:00:00 admin
The new release includes performance improvements and advanced SQL features which will support larger data warehouses, higher-volume transaction processing and more complex distributed enterprise software.
New features in this release include:
Roles:
PostgreSQL now supports database roles, which simplify the management of large numbers of users with complex overlapping database rights.
IN/OUT Parameters:
PostgreSQL functions now support IN, OUT and INOUT parameters, which substantially improves support of complex business logic for J2EE and .NET applications.
Two-Phase Commit (2PC):
Long in demand for WAN applications and heterogeneous data centers using PostgreSQL, this feature allows ACID-compliant transactions across widely separated servers.
Some Performance Enhancements found in this release include:
Improved Multiprocessor (SMP) Performance:
The buffer manager for 8.1 has been enhanced to scale almost linearly with the number of processors, leading to significant performance gains on 8-way, 16-way, dual-core, and multi-core CPU servers.
Bitmap Scan:
Indexes will be dynamically converted to bitmaps in memory when appropriate, giving up to twenty times faster index performance on complex queries against very large tables.
Table Partitioning:
The query planner is now able to avoid scanning whole sections of a large table using a technique known as Constraint Exclusion.
Shared Row Locking:
PostgreSQL's "better than row-level locking" now supports even higher levels of concurrency through the addition of shared row locks for foreign keys.
PostgreSQL 8.1.1 can be downloaded from the following locations:
FTP Mirrors
- http://www.postgresql.org/ftp/latest/
-Windows Installer
- http://www.postgresql.org/ftp/binary/v8.1.1/win32/
Other Binaries, including Linux, Mac OSx and Solaris
- http://www.postgresql.org/ftp/binary/v8.1.1
Installation guideline for PostgreSQL Mac OS X version :
http://developer.apple.com/internet/opensource/postgres.html
Commercial GUI for database management
http://pgsql.navicat.com/download.html
Ratings
Here you can write a comment
Related topics
PHPfaces für komplexe Web-Applikationen
IBM bringt Service Data Objects von Java nach PHP. Das Projekt PHPfaces will eine PHP-Bibliothek für komplexe Web-Frontends entwickeln. Dazu erlaubt es PHPfaces, ein objektorientiertes GUI als Schnittstelle zum Benutzer der Web-Applikation zu erstellen. D ...
Autor :
admin
Category:
Software & Web-Development
PHP T-Shirt
$1.00 jedes verkauften T-Shirts gehen an die PHP Association. Also ran an die Dinger! Der Preis liegt zwischen EUR 11.73 und EUR 20.43 ...
Autor :
admin
Category:
Software & Web-Development
OnPremise versus Cloud - fin the right system
In this article, we highlight the advantages and disadvantages of cloud or on-premise systems. And why it is definitely time to move to the cloud. ...
Autor :
julia_mjr
Category:
Miscellaneous
Internetuser Kleinstudie (Jan. 2001)
Laut der Kleinstudie des schweizer Webdeveloper-Portals metafor.ch war im Januar 2001 der Microsoft Internet Explorer nach wie vor der führende Web- browser im deutschsprachigen Raum. ...
Autor :
admin
Category:
Software & Web-Development
Umfrage: Internet- und IT-Profis ohne Spaß im Job
Die Internet-Branche stand einstmals für ein cooles Image, selbstbestimmtes Arbeiten, hohe Gehälter und ein kumpelhaftes Verhältnis zum Chef. Dieses Bild ist für die meisten Angestellten heute nur noch ein Traum aus vergangenen Zeiten. Nur etwa ein Dritte ...
Autor :
admin
Category:
Software & Web-Development
Auch Altkunden der T-Online-Flatrate können monatlich kündigen !
Die Service-Hotline des Internetproviders T-Online hat bestätigt, dass nicht nur die Neukunden sondern auch die Altkunden jetzt jeden Monat die Nutzung der Flatrate kündigen können. Dies widerspricht den Berichten so mancher Zeitschriften. ...
Autor :
admin
Category:
Software & Web-Development