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

1 files changed, 19 insertions, 5 deletions

diff --git a/databases/postgresql84-server/pkg-plist-client b/databases/postgresql84-server/pkg-plist-client
index 5810e57ecead..cda05962118f 100644
--- a/databases/postgresql84-server/pkg-plist-client
+++ b/databases/postgresql84-server/pkg-plist-client
@@ -16,19 +16,21 @@ bin/pg_dumpall
 bin/pg_resetxlog
 bin/pg_restore
 bin/psql
+bin/reindexdb
 bin/vacuumdb
 include/postgresql/server/access/attnum.h
 include/postgresql/server/access/clog.h
 include/postgresql/server/access/genam.h
 include/postgresql/server/access/gist.h
+include/postgresql/server/access/gist_private.h
 include/postgresql/server/access/gistscan.h
 include/postgresql/server/access/hash.h
 include/postgresql/server/access/heapam.h
 include/postgresql/server/access/hio.h
 include/postgresql/server/access/htup.h
-include/postgresql/server/access/ibit.h
 include/postgresql/server/access/iqual.h
 include/postgresql/server/access/itup.h
+include/postgresql/server/access/multixact.h
 include/postgresql/server/access/nbtree.h
 include/postgresql/server/access/printtup.h
 include/postgresql/server/access/relscan.h
@@ -43,6 +45,8 @@ include/postgresql/server/access/transam.h
 include/postgresql/server/access/tupdesc.h
 include/postgresql/server/access/tupmacs.h
 include/postgresql/server/access/tuptoaster.h
+include/postgresql/server/access/twophase.h
+include/postgresql/server/access/twophase_rmgr.h
 include/postgresql/server/access/valid.h
 include/postgresql/server/access/xact.h
 include/postgresql/server/access/xlog.h
@@ -52,7 +56,6 @@ include/postgresql/server/access/xlogutils.h
 include/postgresql/server/bootstrap/bootstrap.h
 include/postgresql/server/c.h
 include/postgresql/server/catalog/catalog.h
-include/postgresql/server/catalog/catname.h
 include/postgresql/server/catalog/catversion.h
 include/postgresql/server/catalog/dependency.h
 include/postgresql/server/catalog/heap.h
@@ -65,6 +68,9 @@ include/postgresql/server/catalog/pg_amop.h
 include/postgresql/server/catalog/pg_amproc.h
 include/postgresql/server/catalog/pg_attrdef.h
 include/postgresql/server/catalog/pg_attribute.h
+include/postgresql/server/catalog/pg_auth_members.h
+include/postgresql/server/catalog/pg_authid.h
+include/postgresql/server/catalog/pg_autovacuum.h
 include/postgresql/server/catalog/pg_cast.h
 include/postgresql/server/catalog/pg_class.h
 include/postgresql/server/catalog/pg_constraint.h
@@ -73,7 +79,6 @@ include/postgresql/server/catalog/pg_conversion.h
 include/postgresql/server/catalog/pg_database.h
 include/postgresql/server/catalog/pg_depend.h
 include/postgresql/server/catalog/pg_description.h
-include/postgresql/server/catalog/pg_group.h
 include/postgresql/server/catalog/pg_index.h
 include/postgresql/server/catalog/pg_inherits.h
 include/postgresql/server/catalog/pg_language.h
@@ -82,14 +87,14 @@ include/postgresql/server/catalog/pg_listener.h
 include/postgresql/server/catalog/pg_namespace.h
 include/postgresql/server/catalog/pg_opclass.h
 include/postgresql/server/catalog/pg_operator.h
+include/postgresql/server/catalog/pg_pltemplate.h
 include/postgresql/server/catalog/pg_proc.h
 include/postgresql/server/catalog/pg_rewrite.h
-include/postgresql/server/catalog/pg_shadow.h
+include/postgresql/server/catalog/pg_shdepend.h
 include/postgresql/server/catalog/pg_statistic.h
 include/postgresql/server/catalog/pg_tablespace.h
 include/postgresql/server/catalog/pg_trigger.h
 include/postgresql/server/catalog/pg_type.h
-include/postgresql/server/catalog/pg_version.h
 include/postgresql/server/commands/alter.h
 include/postgresql/server/commands/async.h
 include/postgresql/server/commands/cluster.h
@@ -124,6 +129,10 @@ include/postgresql/server/executor/hashjoin.h
 include/postgresql/server/executor/instrument.h
 include/postgresql/server/executor/nodeAgg.h
 include/postgresql/server/executor/nodeAppend.h
+include/postgresql/server/executor/nodeBitmapAnd.h
+include/postgresql/server/executor/nodeBitmapHeapscan.h
+include/postgresql/server/executor/nodeBitmapIndexscan.h
+include/postgresql/server/executor/nodeBitmapOr.h
 include/postgresql/server/executor/nodeFunctionscan.h
 include/postgresql/server/executor/nodeGroup.h
 include/postgresql/server/executor/nodeHash.h
@@ -178,6 +187,7 @@ include/postgresql/server/nodes/primnodes.h
 include/postgresql/server/nodes/print.h
 include/postgresql/server/nodes/readfuncs.h
 include/postgresql/server/nodes/relation.h
+include/postgresql/server/nodes/tidbitmap.h
 include/postgresql/server/nodes/value.h
 include/postgresql/server/optimizer/clauses.h
 include/postgresql/server/optimizer/cost.h
@@ -196,6 +206,7 @@ include/postgresql/server/optimizer/paths.h
 include/postgresql/server/optimizer/plancat.h
 include/postgresql/server/optimizer/planmain.h
 include/postgresql/server/optimizer/planner.h
+include/postgresql/server/optimizer/predtest.h
 include/postgresql/server/optimizer/prep.h
 include/postgresql/server/optimizer/restrictinfo.h
 include/postgresql/server/optimizer/subselect.h
@@ -293,6 +304,7 @@ include/postgresql/server/storage/pg_shmem.h
 include/postgresql/server/storage/pmsignal.h
 include/postgresql/server/storage/pos.h
 include/postgresql/server/storage/proc.h
+include/postgresql/server/storage/procarray.h
 include/postgresql/server/storage/relfilenode.h
 include/postgresql/server/storage/s_lock.h
 include/postgresql/server/storage/shmem.h
@@ -320,6 +332,7 @@ include/postgresql/server/utils/dynahash.h
 include/postgresql/server/utils/dynamic_loader.h
 include/postgresql/server/utils/elog.h
 include/postgresql/server/utils/errcodes.h
+include/postgresql/server/utils/flatfiles.h
 include/postgresql/server/utils/fmgroids.h
 include/postgresql/server/utils/fmgrtab.h
 include/postgresql/server/utils/formatting.h
@@ -340,6 +353,7 @@ include/postgresql/server/utils/palloc.h
 include/postgresql/server/utils/pg_crc.h
 include/postgresql/server/utils/pg_locale.h
 include/postgresql/server/utils/pg_lzcompress.h
+include/postgresql/server/utils/pg_rusage.h
 include/postgresql/server/utils/portal.h
 include/postgresql/server/utils/ps_status.h
 include/postgresql/server/utils/rel.h