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

2 files changed, 12 insertions, 21 deletions

diff --git a/databases/postgresql83-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql83-server/files/patch-src-makefiles-Makefile.freebsd
index 89aaa9a2c0cc..81339e98e8db 100644
--- a/databases/postgresql83-server/files/patch-src-makefiles-Makefile.freebsd
+++ b/databases/postgresql83-server/files/patch-src-makefiles-Makefile.freebsd
@@ -1,14 +1,5 @@
 --- src/makefiles/Makefile.freebsd.orig	Fri Nov 19 01:41:39 2004
 +++ src/makefiles/Makefile.freebsd	Tue Dec 21 02:44:09 2004
-@@ -11,7 +11,7 @@
- ifeq ($(findstring sparc,$(host_cpu)), sparc)
- CFLAGS_SL = -fPIC -DPIC
- else
--CFLAGS_SL = -fpic -DPIC
-+CFLAGS_SL = -fPIC -DPIC
- endif
- 
- 
 @@ -29,3 +29,5 @@
  endif
  
diff --git a/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
index 07363e882113..da57f46e3552 100644
--- a/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
+++ b/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
@@ -1,18 +1,18 @@
---- src/backend/utils/misc/postgresql.conf.sample~	Fri Nov  5 20:16:16 2004
-+++ src/backend/utils/misc/postgresql.conf.sample	Tue Dec 21 02:06:45 2004
-@@ -172,6 +172,7 @@
+--- src/backend/utils/misc/postgresql.conf.sample~	Tue Nov  8 00:45:49 2005
++++ src/backend/utils/misc/postgresql.conf.sample	Tue Nov  8 00:47:16 2005
+@@ -206,6 +206,7 @@
  
  # - Where to Log -
  
 +log_destination = 'syslog'
- #log_destination = 'stderr'	# Valid values are combinations of stderr,
-                                 # syslog and eventlog, depending on
-                                 # platform.
-@@ -219,6 +220,7 @@
- 				 
- #log_min_duration_statement = -1 # -1 is disabled, in milliseconds.
+ #log_destination = 'stderr'		# Valid values are combinations of 
+ 					# stderr, syslog and eventlog, 
+ 					# depending on platform.
+@@ -283,6 +284,7 @@
+ #log_min_duration_statement = -1	# -1 is disabled, 0 logs all statements
+ 					# and their durations, in milliseconds.
  
-+silent_mode = true
- #silent_mode = false		 # DO NOT USE without syslog or redirect_stderr
++silent_mode = on
+ #silent_mode = off			# DO NOT USE without syslog or 
+ 					# redirect_stderr
  
- # - What to Log -