From d587b3a37a4a02fadb87e491df608d71c7f86e07 Mon Sep 17 00:00:00 2001 From: Palle Girgensohn Date: Thu, 10 Nov 2005 02:23:38 +0000 Subject: 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 --- .../files/patch-src-makefiles-Makefile.freebsd | 9 -------- ...h-src:backend:utils:misc:postgresql.conf.sample | 24 +++++++++++----------- 2 files changed, 12 insertions(+), 21 deletions(-) (limited to 'databases/postgresql92-server/files') diff --git a/databases/postgresql92-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql92-server/files/patch-src-makefiles-Makefile.freebsd index 89aaa9a2c0cc..81339e98e8db 100644 --- a/databases/postgresql92-server/files/patch-src-makefiles-Makefile.freebsd +++ b/databases/postgresql92-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/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample index 07363e882113..da57f46e3552 100644 --- a/databases/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ b/databases/postgresql92-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 - -- cgit v1.2.3