PostgreSQL TODO List
====================
Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Thu May 8 23:58:36 EDT 2008
+Last updated: Wed Jun 18 21:15:40 EDT 2008
The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html.
owner is correct.
* -Add function to report the time of the most recent server reload
-* Allow statistics collector information to be pulled from the collector
- process directly, rather than requiring the collector to write a
- filesystem file twice a second?
-* Reduce file system activity overhead of statistics file pgstat.stat
-
- http://archives.postgresql.org/pgsql-general/2007-12/msg00106.php
-
-* Allow statistics last vacuum/analyze execution times to be displayed
- without requiring stats_row_level to be enabled
-
- http://archives.postgresql.org/pgsql-docs/2007-04/msg00028.php
-
* Allow log_min_messages to be specified on a per-module basis
This would allow administrators to see more detailed information from
check that hostname against the host names in pg_hba.conf.
We could also then check that the host name maps to the IP
address.
+ http://archives.postgresql.org/pgsql-hackers/2008-06/msg00569.php
o %Allow postgresql.conf file values to be changed via an SQL
API, perhaps using SET GLOBAL
http://archives.postgresql.org/pgsql-hackers/2007-11/msg00009.php
+ o Add functions to syntax check configuration files
+
* Tablespaces
o Allow per-tablespace quotas
+* Statistics Collector
+
+ o Allow statistics collector information to be pulled from the collector
+ process directly, rather than requiring the collector to write a
+ filesystem file twice a second?
+ o Reduce file system activity overhead of statistics file pgstat.stat
+
+ http://archives.postgresql.org/pgsql-general/2007-12/msg00106.php
+
+ o Allow statistics last vacuum/analyze execution times to be displayed
+ without requiring stats_row_level to be enabled
+
+ http://archives.postgresql.org/pgsql-docs/2007-04/msg00028.php
+
+ o Clear table counters on TRUNCATE
+
+ http://archives.postgresql.org/pgsql-hackers/2008-04/msg00169.php
+
+
* Point-In-Time Recovery (PITR)
o Allow a warm standby system to also allow read-only statements
http://archives.postgresql.org/pgsql-hackers/2006-09/msg01363.php
- o Use LC_TIME for localized weekday/month names, rather than
+ o -Use LC_TIME for localized weekday/month names, rather than
LC_MESSAGES
http://archives.postgresql.org/pgsql-hackers/2006-11/msg00390.php
* Allow DISTINCT to work in multiple-argument aggregate calls
* Add column to pg_stat_activity that shows the progress of long-running
commands like CREATE INDEX and VACUUM
+
+ http://archives.postgresql.org/pgsql-patches/2008-04/msg00203.php
+
* Implement SQL:2003 window functions
-* Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause
+* Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause or
+ target list
http://archives.postgresql.org/pgsql-general/2006-09/msg00803.php
http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php
+ http://archives.postgresql.org/pgsql-hackers/2008-06/msg00124.php
* Increase locking when DROPing objects so dependent objects cannot
get dropped while the DROP operation is happening
Currently non-global system tables must be in the default database
tablespace. Global system tables can never be moved.
- o Prevent parent tables from altering or dropping constraints
+ o -Prevent parent tables from altering or dropping constraints
like CHECK that are inherited by child tables unless CASCADE
is used
- o %Prevent child tables from altering or dropping constraints
+ o -Prevent child tables from altering or dropping constraints
like CHECK that were inherited from the parent table
o Have ALTER INDEX update the name of a constraint using that index
o Add ALTER TABLE RENAME CONSTRAINT, update index name also
http://archives.postgresql.org/pgsql-hackers/2006-12/msg00782.php
+ o Allow an existing index to be marked as a table's primary key
+
+ http://archives.postgresql.org/pgsql-hackers/2008-04/msg00500.php
* CLUSTER
http://archives.postgresql.org/pgsql-hackers/2008-01/msg01009.php
- o Add CASE capability to language (already in SQL)
+ o -Add CASE capability to language (already in SQL)
http://archives.postgresql.org/pgsql-hackers/2008-01/msg00696.php
http://archives.postgresql.org/pgsql-hackers/2007-04/msg00424.php
o Have \d show child tables that inherit from the specified parent
- o Have \l+ show database size, if permissions allow
+ o -Have \l+ show database size, if permissions allow
Ideally it will not generate an error for invalid permissions
Right now all deferred trigger information is stored in backend
memory. This could exhaust memory for very large trigger queues.
- This item involves dumping large queues into files.
+ This item involves dumping large queues into files, or doing some
+ kind of join to process all the triggers, or some bulk operation.
+ http://archives.postgresql.org/pgsql-hackers/2008-05/msg00876.php
* Allow triggers to be disabled in only the current session.
in hopes that empty pages at the end can be truncated by VACUUM
* Allow FSM page return free space based on table clustering, to assist
in maintaining clustering?
-* Improve dead row detection during multi-statement transactions usage
+* -Improve dead row detection during multi-statement transactions usage
http://archives.postgresql.org/pgsql-patches/2007-03/msg00358.php
o Remove configure.in check for link failure when cause is found
o Remove readdir() errno patch when runtime/mingwex/dirent.c rev
1.4 is released
- o Remove psql newline patch when we find out why mingw outputs an
+ o -Remove psql newline patch when we find out why mingw outputs an
extra newline
o Allow psql to use readline once non-US code pages work with
backslashes