The NetBSD Project

CVS log for pkgsrc/databases/postgresql81-server/Attic/Makefile

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql81-server

Request diff between arbitrary revisions


Default branch: MAIN


Revision 1.12, Fri Aug 14 19:41:47 2009 UTC (10 years, 9 months ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2013Q2-base, pkgsrc-2013Q2, pkgsrc-2012Q4-base, pkgsrc-2012Q4, pkgsrc-2011Q4-base, pkgsrc-2011Q4, pkgsrc-2011Q2-base, pkgsrc-2011Q2, pkgsrc-2009Q4-base, pkgsrc-2009Q4, HEAD
Changes since 1.11: +1 -1 lines
FILE REMOVED

Retire PostgreSQL 8.1.

Revision 1.11 / (download) - annotate - [select for diffs], Sat May 16 07:22:01 2009 UTC (11 years ago) by rillig
Branch: MAIN
CVS Tags: pkgsrc-2009Q2-base, pkgsrc-2009Q2
Changes since 1.10: +4 -4 lines
Diff to previous 1.10 (colored)

cleanup: replaced _PKG_SILENT and _PKG_DEBUG with RUN.

Revision 1.10 / (download) - annotate - [select for diffs], Fri Jun 20 08:27:58 2008 UTC (11 years, 11 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2009Q1-base, pkgsrc-2009Q1, pkgsrc-2008Q4-base, pkgsrc-2008Q4, pkgsrc-2008Q3-base, pkgsrc-2008Q3, pkgsrc-2008Q2-base, pkgsrc-2008Q2, cwrapper, cube-native-xorg-base, cube-native-xorg
Changes since 1.9: +1 -2 lines
Diff to previous 1.9 (colored)

Changes 8.1.13:
* Make pg_get_ruledef() parenthesize negative constants (Tom)
  Before this fix, a negative constant in a view or rule might be
  dumped as, say, -42::integer, which is subtly incorrect: it should
  be (-42)::integer due to operator precedence rules. Usually this
  would make little difference, but it could interact with another
  recent patch to cause PostgreSQL to reject what had been a valid
  "SELECT DISTINCT" view query. Since this could result in pg_dump
  output failing to reload, it is being treated as a high-priority
  fix. The only released versions in which dump output is actually
  incorrect are 8.3.1 and 8.2.7.
* Make "ALTER AGGREGATE ... OWNER TO" update pg_shdepend (Tom)
  This oversight could lead to problems if the aggregate was later
  involved in a "DROP OWNED" or "REASSIGN OWNED" operation.

Revision 1.9 / (download) - annotate - [select for diffs], Fri Jan 18 05:06:30 2008 UTC (12 years, 4 months ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2008Q1-base, pkgsrc-2008Q1
Changes since 1.8: +2 -1 lines
Diff to previous 1.8 (colored)

Per the process outlined in revbump(1), perform a recursive revbump
on packages that are affected by the switch from the openssl 0.9.7
branch to the 0.9.8 branch. ok jlam@

Revision 1.8 / (download) - annotate - [select for diffs], Wed Jul 4 20:54:36 2007 UTC (12 years, 11 months ago) by jlam
Branch: MAIN
CVS Tags: pkgsrc-2007Q4-base, pkgsrc-2007Q4, pkgsrc-2007Q3-base, pkgsrc-2007Q3
Changes since 1.7: +5 -2 lines
Diff to previous 1.7 (colored)

Make it easier to build and install packages "unprivileged", where
the owner of all installed files is a non-root user.  This change
affects most packages that require special users or groups by making
them use the specified unprivileged user and group instead.

(1) Add two new variables PKG_GROUPS_VARS and PKG_USERS_VARS to
    unprivileged.mk.  These two variables are lists of other bmake
    variables that define package-specific users and groups.  Packages
    that have user-settable variables for users and groups, e.g. apache
    and APACHE_{USER,GROUP}, courier-mta and COURIER_{USER,GROUP},
    etc., should list these variables in PKG_USERS_VARS and PKG_GROUPS_VARS
    so that unprivileged.mk can know to set them to ${UNPRIVILEGED_USER}
    and ${UNPRIVILEGED_GROUP}.

(2) Modify packages to use PKG_GROUPS_VARS and PKG_USERS_VARS.

Revision 1.7 / (download) - annotate - [select for diffs], Mon Jan 8 18:55:39 2007 UTC (13 years, 4 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2007Q2-base, pkgsrc-2007Q2, pkgsrc-2007Q1-base, pkgsrc-2007Q1
Changes since 1.6: +5 -5 lines
Diff to previous 1.6 (colored)

Changes 8.1.6:
* Improve handling of getaddrinfo() on AIX
  This fixes a problem with starting the statistics collector, among
  other things.
* Fix pg_restore to handle a tar-format backup that contains large
  objects (blobs) with comments
* Fix "failed to re-find parent key" errors in "VACUUM"
* Clean out "pg_internal.init" cache files during server restart
  This avoids a hazard that the cache files might contain stale data
  after PITR recovery.
* Fix race condition for truncation of a large relation across a
  gigabyte boundary by "VACUUM"
* Fix bug causing needless deadlock errors on row-level locks
* Fix bugs affecting multi-gigabyte hash indexes
* Fix possible deadlock in Windows signal handling
* Fix error when constructing an ARRAY[] made up of multiple empty
  elements
* Fix ecpg memory leak during connection
* Fix for Darwin (OS X) compilation
* to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for
  new initdb installs
  This is because lc_numeric can potentially change the output of
  these functions.
* Improve index usage of regular expressions that use parentheses
  This improves psql \d performance also.
* Update timezone database
  This affects Australian and Canadian daylight-savings rules in
  particular.

Revision 1.6 / (download) - annotate - [select for diffs], Sun Nov 5 17:42:30 2006 UTC (13 years, 6 months ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2006Q4-base, pkgsrc-2006Q4
Changes since 1.5: +3 -1 lines
Diff to previous 1.5 (colored)

DESTDIR support.

Revision 1.4.4.1 / (download) - annotate - [select for diffs], Tue Oct 31 10:18:20 2006 UTC (13 years, 7 months ago) by ghen
Branch: pkgsrc-2006Q3
Changes since 1.4: +4 -4 lines
Diff to previous 1.4 (colored) next main 1.5 (colored)

Pullup ticket 1879 - requested by joerg
security updates for postgresql

- pkgsrc/databases/postgresql74/Makefile.common		1.37
- pkgsrc/databases/postgresql74/distinfo		1.22
- pkgsrc/databases/postgresql74-client/Makefile		1.21
- pkgsrc/databases/postgresql74-contrib/Makefile	1.14
- pkgsrc/databases/postgresql74-docs/Makefile		1.10-1.11
- pkgsrc/databases/postgresql74-docs/PLIST		1.7-1.8
- pkgsrc/databases/postgresql74-lib/Makefile		1.26
- pkgsrc/databases/postgresql74-server/Makefile		1.27
- pkgsrc/databases/postgresql74-server/PLIST		1.6
- pkgsrc/databases/postgresql80/Makefile.common		1.24
- pkgsrc/databases/postgresql80/distinfo		1.14
- pkgsrc/databases/postgresql80/options.mk		1.4
- pkgsrc/databases/postgresql80-client/Makefile		1.17
- pkgsrc/databases/postgresql80-client/PLIST		1.12
- pkgsrc/databases/postgresql80-server/Makefile		1.22
- pkgsrc/databases/postgresql81/Makefile.common		1.7
- pkgsrc/databases/postgresql81/distinfo		1.3
- pkgsrc/databases/postgresql81/options.mk		1.2
- pkgsrc/databases/postgresql81-client/Makefile		1.4
- pkgsrc/databases/postgresql81-client/PLIST		1.3
- pkgsrc/databases/postgresql81-server/Makefile		1.5

   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 16:31:24 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql81: Makefile.common distinfo options.mk

   Log Message:
   Changes 8.1.5:
   * Disallow aggregate functions in "UPDATE" commands, except within
     sub-SELECTs (Tom)
     The behavior of such an aggregate was unpredictable, and in 8.1.X
     could cause a crash, so it has been disabled. The SQL standard does
     not allow this either.
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix core dump in duration logging for extended query protocol when
     a "COMMIT" or "ROLLBACK" is executed
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix to_timestamp() for AM/PM formats (Bruce)
   * Fix autovacuum's calculation that decides whether "ANALYZE" is
     needed (Alvaro)
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Minor fixes in /contrib/dblink and /contrib/tsearch2
   * Efficiency improvements in hash tables and bitmap index scans (Tom)
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fix statement_timeout to use the proper units on Win32 (Bruce)
     In previous Win32 8.1.X versions, the delay was off by a factor of
     100.
   * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 16:33:21 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql81-client: Makefile PLIST

   Log Message:
   Changes 8.1.5:
   * Disallow aggregate functions in "UPDATE" commands, except within
     sub-SELECTs (Tom)
     The behavior of such an aggregate was unpredictable, and in 8.1.X
     could cause a crash, so it has been disabled. The SQL standard does
     not allow this either.
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix core dump in duration logging for extended query protocol when
     a "COMMIT" or "ROLLBACK" is executed
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix to_timestamp() for AM/PM formats (Bruce)
   * Fix autovacuum's calculation that decides whether "ANALYZE" is
     needed (Alvaro)
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Minor fixes in /contrib/dblink and /contrib/tsearch2
   * Efficiency improvements in hash tables and bitmap index scans (Tom)
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fix statement_timeout to use the proper units on Win32 (Bruce)
     In previous Win32 8.1.X versions, the delay was off by a factor of
     100.
   * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 16:34:17 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql81-server: Makefile

   Log Message:
   Changes 8.1.5:
   * Disallow aggregate functions in "UPDATE" commands, except within
     sub-SELECTs (Tom)
     The behavior of such an aggregate was unpredictable, and in 8.1.X
     could cause a crash, so it has been disabled. The SQL standard does
     not allow this either.
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix core dump in duration logging for extended query protocol when
     a "COMMIT" or "ROLLBACK" is executed
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix to_timestamp() for AM/PM formats (Bruce)
   * Fix autovacuum's calculation that decides whether "ANALYZE" is
     needed (Alvaro)
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Minor fixes in /contrib/dblink and /contrib/tsearch2
   * Efficiency improvements in hash tables and bitmap index scans (Tom)
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fix statement_timeout to use the proper units on Win32 (Bruce)
     In previous Win32 8.1.X versions, the delay was off by a factor of
     100.
   * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 18:38:57 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql80: Makefile.common distinfo options.mk

   Log Message:
   Changes 8.0.9:
   * Fix crash when referencing NEW row values in rule WHERE expressions
     (Tom)
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 18:39:09 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql80-client: Makefile PLIST

   Log Message:
   Changes 8.0.9:
   * Fix crash when referencing NEW row values in rule WHERE expressions
     (Tom)
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 18:39:19 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql80-server: Makefile

   Log Message:
   Changes 8.0.9:
   * Fix crash when referencing NEW row values in rule WHERE expressions
     (Tom)
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 19:24:07 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql74: Makefile.common distinfo
	pkgsrc/databases/postgresql74-client: Makefile
	pkgsrc/databases/postgresql74-contrib: Makefile
	pkgsrc/databases/postgresql74-docs: Makefile PLIST
	pkgsrc/databases/postgresql74-lib: Makefile
	pkgsrc/databases/postgresql74-server: Makefile PLIST

   Log Message:
   Changes 7.4.14:
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Fix backslash escaping in /contrib/dbmirror
   * Adjust regression tests for recent changes in US DST laws
---
   Module Name:	pkgsrc
   Committed By:	ghen
   Date:		Tue Oct 31 10:12:00 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql74-docs: Makefile PLIST

   Log Message:
   Fix PLIST, bump PKGREVISION.

Revision 1.5 / (download) - annotate - [select for diffs], Wed Oct 18 16:34:17 2006 UTC (13 years, 7 months ago) by adam
Branch: MAIN
Changes since 1.4: +4 -4 lines
Diff to previous 1.4 (colored)

Changes 8.1.5:
* Disallow aggregate functions in "UPDATE" commands, except within
  sub-SELECTs (Tom)
  The behavior of such an aggregate was unpredictable, and in 8.1.X
  could cause a crash, so it has been disabled. The SQL standard does
  not allow this either.
* Fix core dump when an untyped literal is taken as ANYARRAY
* Fix core dump in duration logging for extended query protocol when
  a "COMMIT" or "ROLLBACK" is executed
* Fix mishandling of AFTER triggers when query contains a SQL
  function returning multiple rows (Tom)
* Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
  (Tom)
* Fix string_to_array() to handle overlapping matches for the
  separator string
  For example, string_to_array('123xx456xxx789', 'xx').
* Fix to_timestamp() for AM/PM formats (Bruce)
* Fix autovacuum's calculation that decides whether "ANALYZE" is
  needed (Alvaro)
* Fix corner cases in pattern matching for psql's \d commands
* Fix index-corrupting bugs in /contrib/ltree (Teodor)
* Numerous robustness fixes in ecpg (Joachim Wieland)
* Fix backslash escaping in /contrib/dbmirror
* Minor fixes in /contrib/dblink and /contrib/tsearch2
* Efficiency improvements in hash tables and bitmap index scans (Tom)
* Fix instability of statistics collection on Win32 (Tom, Andrew)
* Fix statement_timeout to use the proper units on Win32 (Bruce)
  In previous Win32 8.1.X versions, the delay was off by a factor of
  100.
* Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
* Fixes for AIX and Intel compilers (Tom)

Revision 1.4 / (download) - annotate - [select for diffs], Sun Apr 23 00:12:37 2006 UTC (14 years, 1 month ago) by jlam
Branch: MAIN
CVS Tags: pkgsrc-2006Q3-base, pkgsrc-2006Q2-base, pkgsrc-2006Q2
Branch point for: pkgsrc-2006Q3
Changes since 1.3: +5 -2 lines
Diff to previous 1.3 (colored)

Modify packages that set PKG_USERS and PKG_GROUPS to follow the new
syntax as specified in pkgsrc/mk/install/bsd.pkginstall.mk:1.47.

Revision 1.3 / (download) - annotate - [select for diffs], Tue Mar 28 19:48:22 2006 UTC (14 years, 2 months ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2006Q1-base, pkgsrc-2006Q1
Changes since 1.2: +1 -14 lines
Diff to previous 1.2 (colored)

Move pre-configure rule for Dragonfly into post-extract rule like
the other postgresql packages do. Fixes build of PL packages.

Revision 1.2 / (download) - annotate - [select for diffs], Tue Mar 21 06:39:33 2006 UTC (14 years, 2 months ago) by martti
Branch: MAIN
Changes since 1.1: +4 -4 lines
Diff to previous 1.1 (colored)

s/wip/databases/ (hi uebayasi!)

Revision 1.1.1.1 / (download) - annotate - [select for diffs] (vendor branch), Mon Mar 20 14:45:51 2006 UTC (14 years, 2 months ago) by uebayasi
Branch: TNF
CVS Tags: pkgsrc-base
Changes since 1.1: +0 -0 lines
Diff to previous 1.1 (colored)

Initial import of PostgreSQL 8.1.3, from pkgsrc-wip.

This is an overview of new features in 8.1.0 against 8.0.x.  8.1.3 includes
many bug fixes since 8.1.0.  Please read documentation of the detailed changes
and procedure of data migration.

Overview

   Major changes in this release:

   Improve concurrent access to the shared buffer cache (Tom)
          Access to the shared buffer cache was identified as a
          significant scalability problem, particularly on multi-CPU
          systems. In this release, the way that locking is done in the
          buffer manager has been overhauled to reduce lock contention and
          improve scalability. The buffer manager has also been changed to
          use a "clock sweep" replacement policy.

   Allow index scans to use an intermediate in-memory bitmap (Tom)
          In previous releases, only a single index could be used to do
          lookups on a table. With this feature, if a query has "WHERE
          tab.col1 = 4 and tab.col2 = 9", and there is no multicolumn
          index on col1 and col2, but there is an index on col1 and
          another on col2, it is possible to search both indexes and
          combine the results in memory, then do heap fetches for only the
          rows matching both the col1 and col2 restrictions. This is very
          useful in environments that have a lot of unstructured queries
          where it is impossible to create indexes that match all possible
          access conditions. Bitmap scans are useful even with a single
          index, as they reduce the amount of random access needed; a
          bitmap index scan is efficient for retrieving fairly large
          fractions of the complete table, whereas plain index scans are
          not.

   Add two-phase commit (Heikki Linnakangas, Alvaro, Tom)
          Two-phase commit allows transactions to be "prepared" on several
          computers, and once all computers have successfully prepared
          their transactions (none failed), all transactions can be
          committed. Even if a machine crashes after a prepare, the
          prepared transaction can be committed after the machine is
          restarted. New syntax includes "PREPARE TRANSACTION" and
          "COMMIT/ROLLBACK PREPARED". A new system view pg_prepared_xacts
          has also been added.

   Create a new role system that replaces users and groups (Stephen Frost)
          Roles are a combination of users and groups. Like users, they
          can have login capability, and like groups, a role can have
          other roles as members. Roles basically remove the distinction
          between users and groups. For example, a role can:

          + Have login capability (optionally)
          + Own objects
          + Hold access permissions for database objects
          + Inherit permissions from other roles it is a member of

          Once a user logs into a role, she obtains capabilities of the
          login role plus any inherited roles, and can use "SET ROLE" to
          switch to other roles she is a member of. This feature is a
          generalization of the SQL standard's concept of roles. This
          change also replaces pg_shadow and pg_group by new role-capable
          catalogs pg_authid and pg_auth_members. The old tables are
          redefined as read-only views on the new role tables.

   Automatically use indexes for MIN() and MAX() (Tom)
          In previous releases, the only way to use an index for MIN() or
          MAX() was to rewrite the query as "SELECT col FROM tab ORDER BY
          col LIMIT 1". Index usage now happens automatically.

   Move /contrib/pg_autovacuum into the main server (Alvaro)
          Integrating autovacuum into the server allows it to be
          automatically started and stopped in sync with the database
          server, and allows autovacuum to be configured from
          "postgresql.conf".

   Add shared row level locks using SELECT ... FOR SHARE (Alvaro)
          While PostgreSQL's MVCC locking allows "SELECT" to never be
          blocked by writers and therefore does not need shared row locks
          for typical operations, shared locks are useful for applications
          that require shared row locking. In particular this reduces the
          locking requirements imposed by referential integrity checks.

   Add dependencies on shared objects, specifically roles (Alvaro)
          This extension of the dependency mechanism prevents roles from
          being dropped while there are still database objects they own.
          Formerly it was possible to accidentally "orphan" objects by
          deleting their owner. While this could be recovered from, it was
          messy and unpleasant.

   Improve performance for partitioned tables (Simon)
          The new constraint_exclusion configuration parameter avoids
          lookups on child tables where constraints indicate that no
          matching rows exist in the child table.

          This allows for a basic type of table partitioning. If child
          tables store separate key ranges and this is enforced using
          appropriate "CHECK" constraints, the optimizer will skip child
          table accesses when the constraint guarantees no matching rows
          exist in the child table.

Revision 1.1 / (download) - annotate - [select for diffs], Mon Mar 20 14:45:51 2006 UTC (14 years, 2 months ago) by uebayasi
Branch: MAIN

Initial revision

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.




CVSweb <webmaster@jp.NetBSD.org>