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

PHP-Kongress verpasst?

Soweit wir bisher sehen konnten war der erste Tag ein voller Erfolg. Livebilder vom Kongress könnt Ihr euch unter php.3uu.de anschauen. Wenn Ihr doch noch Zeit finden solltet - Der Kongress geht noch bis zum 6.10.2000. ...

admin

Autor : admin
Category: Software & Web-Development

IT-Entscheider glauben an Trendwende

Fast 70 Prozent der deutschen IT-Entscheider sind der Meinung, dass sich die Computermesse in Hannover positiv auf die wirtschaftliche Entwicklung in Deutschland auswirken wird. Mehr als 60 Prozent glauben fest daran, dass die Konjunktur in Deutschl ...

admin

Autor : admin
Category: Software & Web-Development

QSC - verbilligt DSL-Flat für Studenten

Der Q-DSL-Zugang von QSC zum Preis von derzeit 59 Euro (115,40 DM) wird jetzt noch billiger. Studenten erhalten die DSL-Flatrate jetzt zum Preis von 51 Euro (99,75 DM). QSC stellt wie bisher einen 1024 kbps Downstream und 128 kbps Upstream bereit. Fü ...

admin

Autor : admin
Category: Software & Web-Development

Google stellt ein neues Bildformat webP vor

Mit WebP will Google das JPG Format auf das Abstellgleis schieben. ...

admin

Autor : admin
Category: Miscellaneous

Das Magazin PHP Solutions Ausgabe 6/2004 (7)

Die Themen der Ausgabe: - PHP-Obfuskatoren und Encoder im Test, - Mambo 4.5 - Power in Simplicity, - Moodle - Implementierung und Verbesserung einer kostenlosen E-Learningplattform, - Fortgeschrittene Möglichkeiten von PHP-Arrays, - PING-PONG, oder ...

admin

Autor : admin
Category: Software & Web-Development

MySQL 5.0 vor der Fertigstellung

Die Open-Source-Datenbank MySQL ist in Version 5.0.13 erschienen, der ersten Ausgabe des 5.x-Entwicklungszweiges, die der Hersteller als Release Candidate bezeichnet. Über den Zeitpunkt der Freigabe einer Stable-Version darf weiter spekuliert werden; eine ...

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