From d32f24776fb6780aaf3c08019692778b7bff1b82 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 7 Dec 2007 17:52:15 +0000 Subject: Remove completed 8.3 TODO items: < o -Allow commenting of variables in postgresql.conf to restore them < to defaults < o -Add a GUC variable to control the tablespace for temporary objects < and sort files < Monitoring < ========== < < * -Allow server log information to be output as CSV format < * -Add ability to monitor the use of temporary sort files < * -Allow user-defined types to accept 'typmod' parameters < < http://archives.postgresql.org/pgsql-hackers/2005-08/msg01142.php < http://archives.postgresql.org/pgsql-hackers/2005-09/msg00012.php < http://archives.postgresql.org/pgsql-hackers/2006-08/msg00149.php < < * -Add Globally/Universally Unique Identifier (GUID/UUID) < < http://archives.postgresql.org/pgsql-patches/2006-09/msg00209.php < http://archives.postgresql.org/pgsql-general/2007-01/msg00853.php < < * -Support a data type with specific enumerated values (ENUM) < o -Add support for arrays of complex types < o -Make 64-bit version of the MONEY data type < * -Add ISO day of week format 'ID' to to_char() where Monday = 1 < * -Add a field 'isoyear' to extract(), based on the ISO week < * -Add RESET SESSION command to reset all session state < o -Make CLUSTER preserve recently-dead tuples per MVCC requirements < o -Add more logical syntax CLUSTER table USING index; < support current syntax for backward compatibility < o -Allow UPDATE/DELETE WHERE CURRENT OF cursor < o -Add support for MOVE cursors < o -Allow PL/PythonU to return boolean rather than 1/0 < o -Allow psql \pset boolean variables to set to fixed values, rather < than toggle < o -Add -f to pg_dumpall < Dependency Checking < =================== < < * -Flush cached query plans when the dependent objects change or < when new ANALYZE statistics are available < * -Track dependencies in function bodies and recompile/invalidate < * -Invalidate prepared queries, like INSERT, when the table definition < is altered < < * -Allow use of indexes to search for NULLs < * -Allow the creation of indexes with mixed ascending/descending < specifiers < * -Reduce checkpoint performance degredation by forcing data to disk < more evenly < * -Allow sequential scans to take advantage of other concurrent < sequential scans, also called "Synchronised Scanning" < * -Consider shrinking expired tuples to just their headers < * -Allow heap reuse of UPDATEd rows if no indexed columns are changed, < and old and new versions are on the same heap page < * -Reduce XID consumption of read-only queries < o -Turn on by default < o -Allow multiple vacuums so large tables do not starve small < tables < * -Allow the pg_xlog directory location to be specified during initdb < with a symlink back to the /data location < * -Allow buffered WAL writes and fsync < * -Allow ORDER BY ... LIMIT # to select high/low value without sort or < index using a sequential scan for highest/lowest values < * -Merge xmin/xmax/cmin/cmax back into three header fields < o -Support a smaller header for short variable-length fields < * -Move NAMEDATALEN from postgres_ext.h to pg_config_manual.h < * -Fix problem with excessive logging during SSL disconnection < < http://archives.postgresql.org/pgsql-bugs/2006-12/msg00122.php < http://archives.postgresql.org/pgsql-bugs/2007-05/msg00065.php < < o -Add long file support for binary pg_dump output --- doc/src/FAQ/TODO.html | 126 +++++++++++--------------------------------------- 1 file changed, 27 insertions(+), 99 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 215176f1926..8b141ac26df 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Mon Nov 26 18:31:05 EST 2007 +Last updated: Fri Dec 7 12:52:05 EST 2007

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -95,9 +95,7 @@ first. There is also a developer's wiki at

  • Configuration files
    • -

    Monitoring

    - - -

    Data Types

    +

    Data Types

  • Binary Data @@ -299,20 +278,17 @@ first. There is also a developer's wiki at
  • MONEY data type
    • -

    Functions

    +

    Functions

    -
  • -Add ISO day of week format 'ID' to to_char() where Monday = 1 -
  • -Add a field 'isoyear' to extract(), based on the ISO week
  • Implement inlining of set-returning functions defined in SQL
  • Allow SQL-language functions to return results from RETURNING queries

    http://archives.postgresql.org/pgsql-hackers/2006-10/msg00665.php @@ -369,7 +343,7 @@ first. There is also a developer's wiki at

    http://archives.postgresql.org/pgsql-patches/2007-08/msg00012.php

    • -

    Multi-Language Support

    +

    Multi-Language Support

    -

    Views / Rules

    +

    Views / Rules

    -

    SQL Commands

    +

    SQL Commands

  • CLUSTER
  • COPY
  • CURSOR
  • INSERT @@ -701,7 +670,6 @@ first. There is also a developer's wiki at
    http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php

  • Add single-step debugging of functions -
  • -Add support for MOVE cursors
  • Add support for SCROLL cursors
  • Add support for WITH HOLD cursors
  • Allow RETURN to return row or record functions @@ -732,7 +700,6 @@ first. There is also a developer's wiki at
  • Add PL/PythonU tracebacks

    http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php

    -
  • -Allow PL/PythonU to return boolean rather than 1/0
  • Allow data to be passed in native language formats, rather than only text

    http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php @@ -740,7 +707,7 @@ first. There is also a developer's wiki at

    • -

    Clients

    +

    Clients

    -

    Triggers

    +

    Triggers

    -

    Dependency Checking

    - - -

    Indexes

    +

    Indexes

    -

    Fsync

    +

    Fsync

    -

    Cache Usage

    +

    Cache Usage

    -
  • -Allow sequential scans to take advantage of other concurrent - sequential scans, also called "Synchronised Scanning"
  • Consider increasing internal areas when shared buffers is increased

    http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php

    @@ -1056,7 +1004,7 @@ first. There is also a developer's wiki at
    http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php

    • -

    Vacuum

    +

    Vacuum

    @@ -1115,9 +1059,6 @@ first. There is also a developer's wiki at
  • %Issue log message to suggest VACUUM FULL if a table is nearly empty?
  • Consider logging activity either to the logs or a system view -
  • -Turn on by default -
  • -Allow multiple vacuums so large tables do not starve small - tables
  • Improve control of auto-vacuum

    http://archives.postgresql.org/pgsql-hackers/2006-12/msg00876.php

    @@ -1127,7 +1068,7 @@ first. There is also a developer's wiki at

    • -

    Locking

    +

    Locking

    -

    Startup Time Improvements

    +

    Startup Time Improvements

    -

    Write-Ahead Log

    +

    Write-Ahead Log

    -

    Optimizer / Executor

    +

    Optimizer / Executor

    -

    Miscellaneous Performance

    +

    Miscellaneous Performance

    -

    Source Code

    +

    Source Code

  • Wire Protocol Changes
    • -

    Exotic Features

    +

    Exotic Features

    -

    Features We Do Not Want

    +

    Features We Do Not Want