diff options
author | Palle Girgensohn <girgen@FreeBSD.org> | 2005-11-10 02:23:38 +0000 |
---|---|---|
committer | Palle Girgensohn <girgen@FreeBSD.org> | 2005-11-10 02:23:38 +0000 |
commit | d587b3a37a4a02fadb87e491df608d71c7f86e07 (patch) | |
tree | 855d5cfe02114a5d512e29fa5e6051ee4416d6cb /databases/postgresql81-client | |
parent | Update to 3.14b (diff) |
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
Notes
Notes:
svn path=/head/; revision=147772
Diffstat (limited to 'databases/postgresql81-client')
-rw-r--r-- | databases/postgresql81-client/Makefile | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/databases/postgresql81-client/Makefile b/databases/postgresql81-client/Makefile new file mode 100644 index 000000000000..017f558f90b5 --- /dev/null +++ b/databases/postgresql81-client/Makefile @@ -0,0 +1,22 @@ +# New ports collection makefile for: PostgreSQL-client +# Date created: Wed Nov 2 00:13:57 CET 2005 +# Whom: Palle Girgensohn <girgen@FreeBSD.org> +# +# $FreeBSD$ +# +# To depend on postgresql-client, set USE_PGSQL=yes. +# See Mk/bsd.databases.mk for more info + +PORTNAME= postgresql +PKGNAMESUFFIX= -client +PORTREVISION= 0 + +COMMENT= PostgreSQL database (client) + +MASTERDIR= ${.CURDIR}/../postgresql81-server + +BUILD_DIRS= src/include src/interfaces src/bin doc src/makefiles +CLIENT_ONLY= yes +INSTALLS_SHLIB= yes + +.include "${MASTERDIR}/Makefile" |