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/FAQ')
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 @@
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
- - -Allow commenting of variables in postgresql.conf to restore them
- to defaults
-
- Allow pg_hba.conf to specify host names along with IP addresses
+
- Allow pg_hba.conf to specify host names along with IP addresses
Host name lookup could occur when the postmaster reads the
pg_hba.conf file, or when the backend starts. Another
solution would be to reverse lookup the connection IP and
@@ -133,8 +131,6 @@ first. There is also a developer's wiki at
requires a tool that will call that function and connect to each
database to find the objects in each database for that tablespace.
- - -Add a GUC variable to control the tablespace for temporary objects
- and sort files
- Allow WAL replay of CREATE TABLESPACE to work when the directory
structure on the recovery computer is different from the original
- Allow per-tablespace quotas
@@ -156,13 +152,7 @@ first. There is also a developer's wiki at
-
-
-
- - -Allow server log information to be output as CSV format
-
- -Add ability to monitor the use of temporary sort files
-
-
+
Binary Data
@@ -299,20 +278,17 @@ first. There is also a developer's wiki at
MONEY data type
- - -Make 64-bit version of the MONEY data type
-
+
- Allow MONEY to be cast to/from other numeric data types
-
+
- Allow INET subnet tests using non-constants to be indexed
@@ -338,8 +314,6 @@ first. There is also a developer's wiki at
- to_char(INTERVAL '43 hours 20 minutes', 'WK:DD:HR:MI') => 0:1:19:20
- to_char(INTERVAL '3 years 5 months','MM') => 41
- -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
-
+
-
+
-
+
- Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT
@@ -483,7 +457,6 @@ first. There is also a developer's wiki at
- Add NOVICE output level for helpful messages like automatic sequence/index
creation
-
- -Add RESET SESSION command to reset all session state
- Add GUC to issue notice about statements that use unjoined tables
- Allow EXPLAIN to identify tables that were skipped because of
constraint_exclusion
@@ -584,8 +557,7 @@ first. There is also a developer's wiki at
CLUSTER
- - -Make CLUSTER preserve recently-dead tuples per MVCC requirements
-
- Automatically maintain clustering on a table
+
- Automatically maintain clustering on a table
This might require some background daemon to maintain clustering
during periods of low usage. It might also require tables to be only
partially filled for easier reorganization. Another idea would
@@ -601,8 +573,6 @@ first. There is also a developer's wiki at
- %Add VERBOSE option to report tables as they are processed,
like VACUUM VERBOSE
-
- -Add more logical syntax CLUSTER table USING index;
- support current syntax for backward compatibility
COPY
@@ -633,8 +603,7 @@ first. There is also a developer's wiki at
CURSOR
- - -Allow UPDATE/DELETE WHERE CURRENT OF cursor
-
- Prevent DROP TABLE from dropping a row referenced by its own open
+
- Prevent DROP TABLE from dropping a row referenced by its own open
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
-
+
-
+
-
-
-
- - -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
-
-
+
-
+
- Improve commit_delay handling to reduce fsync()
@@ -991,10 +943,8 @@ first. There is also a developer's wiki at
- %Add an option to sync() before fsync()'ing checkpoint files
- Add program to test if fsync has a delay compared to non-fsync
-
- -Reduce checkpoint performance degredation by forcing data to disk
- more evenly
-
+
- Allow free-behind capability for large sequential scans to avoid
@@ -1046,8 +996,6 @@ first. There is also a developer's wiki at
- Query execute plan
- Query results
- -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
-
+
@@ -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
-
+
- Fix priority ordering of read and write light-weight locks (Neil)
@@ -1147,7 +1088,7 @@ first. There is also a developer's wiki at
- Add idle_in_transaction_timeout GUC so locks are not held for long
periods of time
-
+
- Experiment with multi-threaded backend for backend creation [thread]
@@ -1170,7 +1111,7 @@ first. There is also a developer's wiki at
existing backends is one of the difficulties with a backend approach.
-
+
- Eliminate need to write full pages to WAL before page modification [wal]
@@ -1199,8 +1140,6 @@ first. There is also a developer's wiki at
entire rows
http://archives.postgresql.org/pgsql-hackers/2007-03/msg01589.php
- - -Allow the pg_xlog directory location to be specified during initdb
- with a symlink back to the /data location
- Allow WAL information to recover corrupted pg_controldata
http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php
@@ -1210,7 +1149,6 @@ first. There is also a developer's wiki at
rotation to fsync again. One idea is to write the WAL to different
offsets that might reduce the rotational delay.
- - -Allow buffered WAL writes and fsync
- Allow WAL logging to be turned off for a table, but the table
might be dropped or truncated during crash recovery [walcontrol]
Allow tables to bypass WAL writes and just fsync() dirty pages on
@@ -1229,12 +1167,10 @@ first. There is also a developer's wiki at
of indexes on TOAST tables.
-
+
-
+
-
+
Wire Protocol Changes
@@ -1390,7 +1318,7 @@ first. There is also a developer's wiki at
of result sets using new statement protocol
-
+
-
+
- All backends running as threads in a single process (not wanted)
--
cgit v1.2.3