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

[Palle Girgensohn]

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