Date: Thu, 10 Nov 2005 02:23:38 +0000 (UTC) From: Palle Girgensohn <girgen@FreeBSD.org> To: ports-committers@FreeBSD.org, cvs-ports@FreeBSD.org, cvs-all@FreeBSD.org Subject: cvs commit: ports/databases/postgresql-contrib Makefile ports/databases/postgresql81-client Makefile ports/databases/postgresql81-server Makefile distinfo pkg-plist-client pkg-plist-contrib pkg-plist-server ports/databases/postgresql81-server/files patch-src-makefiles-Makefile.freebsd patch-src:backend:utils:misc:postgresql.conf.sample Message-ID: <200511100223.jAA2NcW6031094@repoman.freebsd.org>
next in thread | raw e-mail | index | archive | help
girgen 2005-11-10 02:23:38 UTC
FreeBSD ports repository
Modified files:
databases/postgresql-contrib Makefile
databases/postgresql81-server Makefile distinfo
pkg-plist-client
pkg-plist-contrib
pkg-plist-server
databases/postgresql81-server/files
patch-src-makefiles-Makefile.freebsd
patch-src:backend:utils:misc:postgresql.conf.sample
Added files:
databases/postgresql81-client Makefile
Log:
Welcome to PostgreSQL 8.1.
The new release includes performance improvements and advanced SQL
features which will support bigger data warehouses, higher-volume
transaction processing, and more complex distributed enterprise
software.
Major 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.
For a more complete listing of changes in this release, please see the
Release Notes visible at:
http://www.postgresql.org/docs/current/static/release.html#RELEASE-8-1
Revision Changes Path
1.11 +3 -1 ports/databases/postgresql-contrib/Makefile
1.1 +22 -0 ports/databases/postgresql81-client/Makefile (new)
1.146 +25 -31 ports/databases/postgresql81-server/Makefile
1.43 +15 -12 ports/databases/postgresql81-server/distinfo
1.3 +0 -9 ports/databases/postgresql81-server/files/patch-src-makefiles-Makefile.freebsd
1.3 +12 -12 ports/databases/postgresql81-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
1.6 +19 -5 ports/databases/postgresql81-server/pkg-plist-client
1.3 +3 -32 ports/databases/postgresql81-server/pkg-plist-contrib
1.5 +4 -1 ports/databases/postgresql81-server/pkg-plist-server
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200511100223.jAA2NcW6031094>