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

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 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
Author

Ratings

There are no comments available yet.

Here you can write a comment


Please enter at least 10 characters.
Loading... Please wait.
* Pflichtangabe

Related topics

LAMP kompakt auf dem Linux-Tag 2005

Unternehmen rund um die LAMP-Plattform präsentieren sich in Karlsruhe in der LAMP-Area Bereits zum zweiten Mal finden sich namhafte Anbieter, Projekte und Förderer der LAMP-Plattform auf dem Karlsruher Linux-Tag in einem gemeinsamen Bereich wieder. Vom ...

admin

Autor : admin
Category: Software & Web-Development

GMX Viren-Report

Aktuelle Virenwarnungen 15.01. Troj/Mmdload-A 15.01. W32/Rirc-A 14.01. Troj/Inor-B 12.01. W32/Randex-Y 09.01. Troj/Dloader-L Viren - TOP 5 W32/Sober-C W32/Mimail-K W32/Dumaru-A W32/Mimail-J W32/Mimail-C Quelle: Sophos "Sie dro ...

admin

Autor : admin
Category: Software & Web-Development

O'Reilly gibt Bücher zum Download frei

Der US-amerikanische Buchverlag O'Reilly & Associates hat angekündigt, mehrere hundert Bücher unter die Lizenzbedingungen des Creative-Commons-Projekts zu stellen. Vorbehaltlich der Zustimmung der einzelnen Autoren sollen in den nächsten Wochen 157 be ...

admin

Autor : admin
Category: Software & Web-Development

T-online ändert Tarifemodell - T-online Flat wurde abgeschafft

Mit einem komplett neuem Tarifmodell sorg T-Online für Wirbel in sämtlichen Online-Communitys. Hauptmerkmal ist die Abschaffung der T-online Flat (nur für ISDN, T-DSL flat bleibt bestehen), sowie ne Menge neuer Tarife wie " T-Online by night " wo man zwis ...

admin

Autor : admin
Category: Software & Web-Development

Internet Explorer 5.5 und 6.0 - Cookies klauen leicht gemacht

Der Finne Jouko Pynnonen entdeckte einen neuen Bug im Internet Explorer 5.5 und 6.0. Pynnonen bestätigte, dass man durch einen kleinen Trick Cookies auslesen und sogar verändern kann. Nach der Eingabe von 'about:' im URL-Feld, ist es möglich Java-Scr ...

admin

Autor : admin
Category: Software & Web-Development

PHP 5.3.9 behebt Hash-bug

Die PHP-Version 5.3.9 behebt einen Bug, der DoS-Attacken über eine Hash-Kollisionen verhindern soll. ...

admin

Autor : admin
Category: Software & Web-Development

Maßstäbe im Shophosting seit über 15 Jahren
Greifswald, Deutschland

Publish a press release

Share your news and information

Share your news and information with others

You want to inform other users about an interesting IT topic, then sign up now and share it with our PHP community

learn more

Publish a press release